[PERFORM] Major differences between oracle and postgres performance - what can I do ?

2004-06-18 Thread Gary Cowell
I'm trying to migrate an application from an Oracle backend to PostgreSQL and have a performance question. The hardware for the database is the same, a SunFire v120, 2x73GB U2W SCSI disks, 1GB RAM, 650MHz US-IIe CPU. Running Solaris 8. The table in question has 541741 rows. Under Oracle, the

Re: [PERFORM] Performance over a LAN

2004-07-23 Thread Gary Cowell
--- William Carney [EMAIL PROTECTED] wrote: The test program is a C program with embedded SQL (ecpg). The only difference between the tests was the address used in the EXEC SQL CONNECT .. statement. The inserts are committed to the database by performing an EXEC SQL COMMIT after every N

Re: [PERFORM] \d output to a file

2004-12-15 Thread Gary Cowell
On Wed, 15 Dec 2004 06:38:22 -0800 (PST), sarlav kumar [EMAIL PROTECTED] wrote: Hi All, I would like to write the output of the \d command on all tables in a database to an output file. There are more than 200 tables in the database. I am aware of \o command to write the output to a file.