From: Gregory Stark <stark@enterprisedb.com>
To: Dimitri <dimitrik.fr@gmail.com>
Cc: Heikki Linnakangas <heikki@enterprisedb.com>
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Filesystem Direct I/O and WAL sync option
Date: Wed, 04 Jul 2007 11:45:01 +0100
Message-ID: <87wsxgcus2.fsf@oxford.xeocode.com> (raw)
In-Reply-To: <5482c80a0707040326v1229f11dh2a69278365c1de8c@mail.gmail.com>
References: <5482c80a0707030754o740c82b6s4598dc668720d014@mail.gmail.com>
<468A65F5.8020800@enterprisedb.com>
<5482c80a0707030826v38c59870ib90599ba43337e72@mail.gmail.com>
<87lkdx0y5d.fsf@oxford.xeocode.com>
<5482c80a0707040326v1229f11dh2a69278365c1de8c@mail.gmail.com>
"Dimitri" <dimitrik.fr@gmail.com> writes:
> Yes Gregory, that's why I'm asking, because from 1800 transactions/sec
> I'm jumping to 2800 transactions/sec! and it's more than important
> performance level increase :))
wow. That's kind of suspicious though. Does the new configuration take
advantage of the lack of the filesystem cache by increasing the size of
shared_buffers? Even then I wouldn't expect such a big boost unless you got
very lucky with the size of your working set compared to the two sizes of
shared_buffers.
It seems likely that somehow this change is not providing the same guarantees
as fsync. Perhaps fsync is actually implementing IDE write barriers and the
sync mode is just flushing buffers to the hard drive cache and then returning.
What transaction rate do you get if you just have a single connection
streaming inserts in autocommit mode? What kind of transaction rate do you get
with both sync mode on and fsync=on in Postgres?
And did you say this with a battery backed cache? In theory fsync=on/off and
shouldn't make much difference at all with a battery backed cache. Stranger
and stranger.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: stark@enterprisedb.com, dimitrik.fr@gmail.com, heikki@enterprisedb.com
Subject: Re: Filesystem Direct I/O and WAL sync option
In-Reply-To: <87wsxgcus2.fsf@oxford.xeocode.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox