Re: good pc but bad performance,why?

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: huang yaqin <hyq(at)gthome(dot)com>
Cc: Richard Huxton <dev(at)archonet(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: good pc but bad performance,why?
Date: 2004-04-07 09:53:59
Message-ID: Pine.LNX.4.44.0404071152370.4551-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Steven Butler 2004-04-07 10:39:25 Re: good pc but bad performance,why?
Previous Message Ken Geis 2004-04-07 09:03:27 Re: plan problem