Re: Slow insert performace, 8.3 Wal related?

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Bill Preston <billpreston(at)crownepointe(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow insert performace, 8.3 Wal related?
Date: 2009-01-14 10:10:17
Message-ID: 496DBA09.20509@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Euler Taveira de Oliveira 2009-01-14 13:39:51 Re: index
Previous Message David Wilson 2009-01-14 06:16:13 Re: index