[PERFORM] Importing from pg_dump slow, low Disk IO

2005-06-08 Thread Steve Pollard
Hi Everyone, Im having a performance issue with version 7.3.4 which i first thought was Disk IO related, however now it seems like the problem is caused by really slow commits, this is running on Redhat 8. Basically im taking a .sql file with insert of about 15,000 lines and <'ing straight in

Re: [PERFORM] Importing from pg_dump slow, low Disk IO

2005-06-08 Thread Steve Pollard
Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Pollard Sent: Wednesday, 8 June 2005 6:39 PM To: pgsql-performance@postgresql.org Subject: [PERFORM] Importing from pg_dump slow, low Disk IO Hi Everyone, Im having a performance issue with version 7.3.4 which i first

Re: [PERFORM] Importing from pg_dump slow, low Disk IO

2005-06-09 Thread Steve Pollard
s has increased the speed on my Redhat 8 servers my 20X ! Steve -Original Message- From: Steve Pollard Sent: Thursday, 9 June 2005 1:27 PM To: Steve Pollard; pgsql-performance@postgresql.org Subject: RE: [PERFORM] Importing from pg_dump slow, low Disk IO As a follow up to this ive install