Re: PostgreSQL Write Performance

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: Greg Smith <greg(at)2ndquadrant(dot)com>
Cc: Yan Cheng Cheok <yccheok(at)yahoo(dot)com>, Dann Corbit <DCorbit(at)connx(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL Write Performance
Date: 2010-01-07 10:29:50
Message-ID: 87iqbe9pi9.fsf@hi-media-techno.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greg Smith <greg(at)2ndquadrant(dot)com> writes:
> If you're OK with the possibility of losing a measurement in the case of a
> system crash

Then I'd say use synchronous_commit = off for the transactions doing
that, trading durability (the 'D' of ACID) against write
performances. That requires 8.3 at least, and will not fsync() before
telling the client the commit is done.

Regards,
--
dim

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Konrad Garus 2010-01-07 10:45:22 Re: Rows missing from table despite FK constraint
Previous Message Konrad Garus 2010-01-07 10:12:24 Rows missing from table despite FK constraint