X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D7B71D1B538 for ; Wed, 15 Oct 2003 10:28:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 18241-09 for ; Wed, 15 Oct 2003 07:28:03 -0300 (ADT) Received: from gateway.vault-id.com (unknown [203.115.192.108]) by svr1.postgresql.org (Postfix) with SMTP id CAFA1D1B4EF for ; Wed, 15 Oct 2003 07:27:54 -0300 (ADT) Received: (qmail 26160 invoked from network); 15 Oct 2003 10:08:55 -0000 Received: from unknown (HELO bytecraft.com.my) (219.93.229.26) by mail.bytecraft.com.my with SMTP; 15 Oct 2003 10:08:55 -0000 Message-ID: <3F8D208F.2020702@bytecraft.com.my> Date: Wed, 15 Oct 2003 18:25:19 +0800 From: Ang Chin Han User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2.1) Gecko/20030225 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Bruce Momjian Cc: "scott.marlowe" , Postgresql Performance Subject: Re: further testing on IDE drives References: <200310101724.h9AHOTs24892@candle.pha.pa.us> In-Reply-To: <200310101724.h9AHOTs24892@candle.pha.pa.us> X-Enigmail-Version: 0.71.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigB3CABE5E4499A0406330E725" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/470 X-Sequence-Number: 4218 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigB3CABE5E4499A0406330E725 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Bruce Momjian wrote: > Yes. If you were doing multiple WAL writes before transaction fsync, > you would be fsyncing every write, rather than doing two writes and > fsync'ing them both. I wonder if larger transactions would find > open_sync slower? No hard numbers, but I remember testing fsync vs open_sync something ago on 7.3.x. open_sync was blazingly fast for pgbench, but for when we switched our development database over to open_sync, things slowed to a crawl. This was some months ago, and I might be wrong, so take it with a grain of salt. It was on Red Hat 8's Linux kernel 2.4.18, I think. YMMV. Will be testing it real soon tonight, if possible. --------------enigB3CABE5E4499A0406330E725 Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE/jSCUNYbTUIgzwfARAqIXAKCi1u9ej1qWQiC+z14ZcwtKiJzJFACg3QgU QO8K86peq3/1N3hGiWpqJVY= =qihu -----END PGP SIGNATURE----- --------------enigB3CABE5E4499A0406330E725--