|
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
|
Where are the files for my PostgreSQL database stored? I know that with MySQL it stores a file for each table and that PostgreSQL does something different but it's got to store it's data somewhere when I turn my computer off and I'm trying to figure out...
Started by Teifion on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
The data for a particular database is under (for example) C:\Program Files\PostgreSQL\8.1\data\base\100929 , where I guess 100929 is the database ( ) TABLESPACE dbspace....
Is at somewhere like C:\Program Files\PostgreSQL\8.1\data .
|
|
When I connect to a MySQL database using PDO, the way I need to connect is: $pdoConnection = new PDO("mysql:host=hostname;dbname=databasename",user,password);
But, for PostgreSQL, the DSN is more standard (IMO): $pdoConnection = new PDO("pgsql:host=hostname...
Started by Vern Takebayashi on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
As the person that implemented both, I can tell you that the reason is that by passing the string through... .
It's just an accident that the person who implemented the mysql connector did it differently than the person who implemented the pgsql connector .
|
|
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.
|
|
Is there an alternative for mysql_insert_id() php function for PostgreSQL? Most of the frameworks are solving the problem partially by finding the current value of the sequence used in the ID. However, there are times that the primary key is not a serial...
Started by Jeffrey04 on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
OIDs have been off by default since PostgreSQL 8.1.Check out the RETURNING....
...; $insert_id = SELECT lastval(); -- works for PostgreSQL >= 8.1
$insert_id = SELECT nextval PostgreSQL)
pg_last_oid() only works where you have OIDs.
|
|
Hello all,
Just trying out Postgresql for the first time, coming from MySQL. In our Rails application we have a couple of locations with SQL like so:
SELECT * FROM `currency_codes` ORDER BY FIELD(code, 'GBP', 'EUR', 'BBD', 'AUD', 'CAD', 'USD') DESC, name...
Started by Peer Allan on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Right now; however, I can work backwards to a "morally" equivalent version that works on the 8.1 | USD 12 | USD (12 rows)
In PostgreSQL 8.4 you can also use a function with variable number.
|
|
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).
|
|
A dumbveloper at my work (years ago) moved the body column from our comments table to a secondary comment_extensions table as some sort of sketchy guesswork optimization. It seems ill-advised to do a join every time we want to display a comment, so I'...
Answer Snippets (Read the full thread at stackoverflow):
Be almost enough (you'd need to still recreate indexes and so on) but I remember Postgres 8.1 has a bug.
|
