Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow insert performace, 8.3 Wal related? - Mailing list pgsql-performance

From Heikki Linnakangas
Subject Re: Slow insert performace, 8.3 Wal related?
Date
Msg-id 496DBA09.20509@enterprisedb.com
Whole thread Raw
In response to Re: Slow insert performace, 8.3 Wal related?  (Bill Preston <billpreston@crownepointe.net>)
List pgsql-performance
Tree view 
Bill Preston wrote:
> Fsync is off in 8.3.

You should consider turning synchronous_commit off instead. That's
almost as good as fsync=off performance-wise, but doesn't leave your
database corrupt in case of power loss or OS crash.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

pgsql-performance by date:

Previous
From: "David Wilson"
Date:
Subject: Re: index
Next
From: Euler Taveira de Oliveira
Date:
Subject: Re: index