|
I'm working on a PostgreSQL 8.1 SQL script which needs to delete a large number of rows from a table.
Let's say the table I need to delete from is Employees (~260K rows). It has primary key named id.
The rows I need to delete from this table are stored...
Started by Jin Kim on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
PostgreSQL should select....
The JOIN predicate, on the other hand, may benefit from using .
PostgreSQL in PostgreSQL compared to SEQ SCAN .
EmployeesToDelete ed WHERE id = ed.employee_id;
This totally depend on your index selectivity .
|
|
Where does the -base come from? Why the word base , as version 8.1 is simply named postgresql .
Started by Cheng on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
There are a number of core postgresql-related....
So the idea is apparently that you use this if you don't want to install the full server, whose package name is postgresql .
The package description is "PostgreSQL libraries and clients".
|
|
Is there a simple way to create a copy of a database or schema in PostgreSQL 8.1?
I'm testing some software which does a lot of updates to a particular schema within a database, and I'd like to make a copy of it so I can run some comparisons against the...
Started by Jin Kim on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
You can use the backup to restore to a different server or ... .
(Link goes to 7.4 docs but if you just Google pg_dump you will get links to every version)
here is a link to some examples of backing up and restoring .
Pg_dump with the --schema-only option.
|
Ask your Facebook Friends
|
A) What is the best solution for regularly backing up large PostgreSQL database (version 8.3 running on latest Ubuntu server); please don't say pg_dump with those painfully slow insert statements
B) What is the best solution for PostgreSQL database replication...
Answer Snippets (Read the full thread at stackoverflow):
It is being done through is finished, just run psql "SELECT pg... .
In the postgresql.conf all you need to do backup, you need to first tell PostgreSQL that you're taking a backup.
A couple of times for 8.1, but it should be the same in 8.3.
|
|
Hi all, I tried to enlarge the value of the "shared_buffers" settings to be larger then a default 24Mb, and the server doesn't starts with other values (I tried some) except of the default one. Just an empty logfile is created. It's a clean installation...
Started by jutky on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
I've found that if I manually terminal)
What version of PostgreSQL is this? I've run into issues using the "Mb" syntax for older PostgreSQL and distro).....
Version of PostgreSQL (it did not work on 8.1, but it works on 8.3).
|
|
Hi again,
I am currently cleaning up a table with 2 indexes and 250 million active rows and approximately as many dead rows (or more). I issued the command VACCUM FULL ANALYSE from my client computer (laptop) to my server. It has been going about its ...
Started by Nicholas Leonard on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Btw, 8.4 will have ....
Use a newer PostgreSQL.
Set the maintenance_work_mem really high.
Is it possible it is pre-8.0?
I had enough (especially on such an old PosgreSQL as 8.1).
You don't say what version of PostgreSQL you are using.
|
|
I would like to group multiple queries into a single function that lives in PostgreSQL. The function will be queried using PDO.
The function is:
CREATE OR REPLACE FUNCTION "test_multipe_refcursor"() RETURNS SETOF refcursor AS $BODY$ DECLARE parentRC refcursor...
Started by Some Canuck on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Support for returning multiple resultsets is still on the PostgreSQL todo list of this PostgreSQL doc page , there is a section describing how you can pass back one or more cursors FROM a; FETCH ALL FROM b; COMMIT;
The page is for PostgreSQL....
|
|
Hey,
I've got a "little" problem. A week ago my database was reaching full disk capasity. I deleted many rows in different tables trying to free up disk space. After wich i tried running a full vacuum wich did not complete.
What i want to know is. When...
Started by jorgen on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
The best.
First of all:
UPGRADE Even if you can't to 8.2, 8.3 or 8.4 - at least upgrade to newest 8.1 (which?
Check with df what is total used space, and then check how much of it is PostgreSQL directory.
|
|
Hi all
I have spent hours on the net looking for a solution to convert a PostGreSQL databse to MySQL, and came up blank. The psql currently sits on a Linux box running SuSe, and the MySQL sits on A Windows machine.
Is there a way to convert the way I ...
Started by Hong Man on
, 17 posts
by 13 people.
Answer Snippets (Read the full thread at mysql):
Rob postgres....
It's not limited to PostgreSQL and MySQL - it handles some commercial
dbs well too notification of your post.
To postgreSQL but not to MySql I have written a plugin to the SQuirreL SQL Client (www.squirrelsql.org of the other.
|
|
Hi guys!
Im wondering if the way i use to retrieve the id of the last row inserted in a postgresql table is efficent..
It works, obviously, but referencing on the serial sequence currval value could be problematic when i have many users adding rows in...
Started by DaNieL on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
If you use a newer version of PostgreSQL (> 8.1) you should use the RETURNING clause of INSERT.
|
