Horton

Re: good pc but bad performance,why?

Dennis Björklund <db@zigo.dhs.org>

View thread
From: Dennis Bjorklund <db@zigo.dhs.org>
To: huang yaqin <hyq@gthome.com>
Cc: Richard Huxton <dev@archonet.com>, "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: 2004-04-07T09:53:59Z
Lists: pgsql-performance 
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