It sounds almost like you're doing one insert per transaction. Try wrapping
multiple inserts into a single transaction and see if that helps. This may
not be appropriate for your application, but it does guarantee that
committed transactions will not be lost.
My apologies if you are already doing this. :)
BEGIN;
insert ...
insert ...
insert ...
COMMIT;
Regards,
Steve Butler
----- Original Message -----
From: "huang yaqin" <hyq@gthome.com>
To: "Richard Huxton" <dev@archonet.com>
Cc: <pgsql-performance@postgresql.org>
Sent: Wednesday, April 07, 2004 6:56 PM
Subject: Re: [PERFORM] good pc but bad performance,why?
Hello, Richard Huxton,
You said turning fsync off may cause losing data, that's terrible.
I use SCSI disk, and file system is ext3. I tune postgresql.conf and can't
get any improvement. So what can I do?
Does SCSI disk and IDE disk have difference?
Regards,
Huang yaqin
