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 13:17:16 -0700
Message-ID: <20060306201716.GA14663@winnie.fuhr.org> (raw)
In-Reply-To: <A3D1526C98B7C1409A687E0943EAC410605FC3@obelix.askesis.nl>
References: <A3D1526C98B7C1409A687E0943EAC410605FC3@obelix.askesis.nl>
On Mon, Mar 06, 2006 at 07:46:05PM +0100, Joost Kraaijeveld wrote:
> Michael Fuhr wrote:
> > What's your setting?
>
> Default.
Have you tweaked postgresql.conf at all? If so, what non-default
settings are you using?
> > Are your test results more consistent
> > if you execute CHECKPOINT between them?
>
> Could you tell me how I could do that?
Connect to the database as a superuser and execute a CHECKPOINT
statement.
http://www.postgresql.org/docs/8.1/interactive/sql-checkpoint.html
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: <20060306201716.GA14663@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