On Wed, 7 Apr 2004, huang yaqin wrote:
> 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?
Make sure you do as much as possible inside one transaction. If you want
to do 1000 inserts, then do BEGIN; insert ....; insert; ... ; COMMIT;
--
/Dennis Björklund