Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 980692E3979 for ; Tue, 22 Jan 2008 04:32:35 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 82931-03 for ; Tue, 22 Jan 2008 04:32:25 -0400 (AST) Received: from mx01.bfk.de (mx01.bfk.de [193.227.124.2]) by postgresql.org (Postfix) with ESMTP id 913E52E3693 for ; Tue, 22 Jan 2008 04:32:27 -0400 (AST) Received: from mx00.int.bfk.de ([10.119.110.2]) by mx01.bfk.de with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) id 1JHEYS-0005r9-Vm; Tue, 22 Jan 2008 09:32:25 +0100 Received: from fweimer by bfk.de with local id 1JHEYT-0003hR-N1; Tue, 22 Jan 2008 09:32:25 +0100 To: Hannes Dorbath Cc: pgsql-performance@postgresql.org Subject: Re: 8.3 synchronous_commit References: From: Florian Weimer Date: Tue, 22 Jan 2008 09:32:25 +0100 In-Reply-To: (Hannes Dorbath's message of "Mon, 21 Jan 2008 22:55:16 +0100") Message-ID: <82d4rumfae.fsf@mid.bfk.de> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/173 X-Sequence-Number: 28412 * Hannes Dorbath: > I might completely misunderstand this feature. Shouldn't > "synchronous_commit =3D 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. --=20 Florian Weimer BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstra=DFe 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99