From: Ivan Voras <ivoras@geri.cc.fer.hr>
To: pgsql-performance@postgresql.org
Subject: Re: Performance tuning on FreeBSD
Date: Tue, 04 Mar 2008 15:07:57 +0100
Message-ID: <fqjkst$sgp$1@ger.gmane.org> (raw)
In-Reply-To: <Pine.GSO.4.64.0803032005020.23114@westnet.com>
References: <892916310803031539scffd5bchcce5a848b3a57a32@mail.gmail.com>
<Pine.GSO.4.64.0803032005020.23114@westnet.com>
Greg Smith wrote:
> On Mon, 3 Mar 2008, alan bryan wrote:
>
>>> pgbench -c 100 -t 1000 testdb
>> tps = 558.013714 (excluding connections establishing)
>>
>> Just for testing, I tried turning off fsync and got:
>> tps = 4061.662041 (excluding connections establishing)
>
> This is odd. ~500 is what I expect from this test when there is no
> write cache to accelerate fsync, while ~4000 is normal for your class of
> hardware when you have such a cache.
I'm curious about the math behind this - is ~4000 burst or sustained
rate? For common BBU cache sizes (256M, 512M), filling that amount with
data is pretty trivial. When the cache is full, new data can enter the
cache only at a rate at which old data is evacuated from the cache (to
the drive), which is at "normal", uncached disk drive speeds.
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: ivoras@geri.cc.fer.hr
Subject: Re: Performance tuning on FreeBSD
In-Reply-To: <fqjkst$sgp$1@ger.gmane.org>
* 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