Re: PostgreSQL Write Performance - Mailing list pgsql-general

From Dimitri Fontaine
Subject Re: PostgreSQL Write Performance
Date
Msg-id 87iqbe9pi9.fsf@hi-media-techno.com
Whole thread Raw
In response to Re: PostgreSQL Write Performance  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-general
Greg Smith <greg@2ndquadrant.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

pgsql-general by date:

Previous
From: Konrad Garus
Date:
Subject: Rows missing from table despite FK constraint
Next
From: Konrad Garus
Date:
Subject: Re: Rows missing from table despite FK constraint