From: Hannes Dorbath <light@theendofthetunnel.de>
To: Guillaume Smet <guillaume.smet@gmail.com>
Subject: Re: 8.3 synchronous_commit
Date: Tue, 22 Jan 2008 12:56:59 +0100
Message-ID: <4795DA0B.7000202@theendofthetunnel.de> (raw)
In-Reply-To: <1d4e0c10801220049p7b184a52s1b2b2e86bc414395@mail.gmail.com>
References: <fn34ca$2ff8$1@news.hub.org>
<82d4rumfae.fsf@mid.bfk.de>
<1d4e0c10801220049p7b184a52s1b2b2e86bc414395@mail.gmail.com>
Guillaume Smet wrote:
> Also with SATA? If your SATA disk is lying about effectively SYNCing
> the data, I'm not that surprised you don't see any improvement. Being
> slower is a bit surprising though.
The disc is not lying, but LVM does not support write barriers, so the
result is the same. Indeed nothing is flushing the disc's write cache on
fsync. However I could disable the disc's write cache entirely. One
reason why I'm a ZFS fan boy lately. It just get's all of this right by
*default*.
Anyway, with some further testing my benchmark results vary so much that
further discussion seems pointless. I'll repost when I really have
reproducible values and followed Greg Smith's advice.
--
Best regards,
Hannes Dorbath
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: light@theendofthetunnel.de, guillaume.smet@gmail.com
Subject: Re: 8.3 synchronous_commit
In-Reply-To: <4795DA0B.7000202@theendofthetunnel.de>
* 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