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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend