Re: 8.3 synchronous_commit - Mailing list pgsql-performance

From Florian Weimer
Subject Re: 8.3 synchronous_commit
Date
Msg-id 82d4rumfae.fsf@mid.bfk.de
Whole thread Raw
In response to 8.3 synchronous_commit  (Hannes Dorbath <light@theendofthetunnel.de>)
Responses Re: 8.3 synchronous_commit
List pgsql-performance
* Hannes Dorbath:

> I might completely misunderstand this feature. Shouldn't
> "synchronous_commit = off" improve performance?

Indeed.

We've seen something similar in one test, but couldn't reproduce it in
a clean environment so far.

> Maybe it's just my test box.. single SATA-II drive, XFS on top of LVM.

Ours was ext3, no LVM or RAID.

--
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99

pgsql-performance by date:

Previous
From: Adrian Moisey
Date:
Subject: Re: scheduler
Next
From: david@lang.hm
Date:
Subject: Re: scheduler