From: Michael Fuhr <mike@fuhr.org>
To: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
Cc: Pgsql-Performance (E-mail) <pgsql-performance@postgresql.org>
Subject: Re: Can anyone explain this pgbench results?
Date: Mon, 6 Mar 2006 10:47:42 -0700
Message-ID: <20060306174742.GA13788@winnie.fuhr.org> (raw)
In-Reply-To: <A3D1526C98B7C1409A687E0943EAC410605FC1@obelix.askesis.nl>
References: <A3D1526C98B7C1409A687E0943EAC410605FC1@obelix.askesis.nl>
On Mon, Mar 06, 2006 at 04:29:49PM +0100, Joost Kraaijeveld wrote:
> Below are some results of running pgbench, run on a machine that
> is doing nothing else than running PostgreSQL woth pgbench. The
> strange thing is that the results are *constantly alternating* hight
> (750-850 transactions)and low (50-80 transactions), no matter how
> many test I run. If I wait a long time (> 5 minutes) after running
> the test, I always get a hight score, followed by a low one, followed
> by a high one, low one etc.
The default checkpoint_timeout is 300 seconds (5 minutes). Is it
coincidence that the "long time" between fast results is about the
same? What's your setting? Are your test results more consistent
if you execute CHECKPOINT between them?
--
Michael Fuhr
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: mike@fuhr.org, J.Kraaijeveld@Askesis.nl
Subject: Re: Can anyone explain this pgbench results?
In-Reply-To: <20060306174742.GA13788@winnie.fuhr.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