From: Steve Poe <spoe@sfnet.cc>
To: Thomas F.O'Connell <tfo@sitening.com>
Cc: PgSQL - Performance <pgsql-performance@postgresql.org>
Subject: Re: pgbench Comparison of 7.4.7 to 8.0.2
Date: Tue, 26 Apr 2005 10:49:46 -0700
Message-ID: <426E7F3A.8000500@sfnet.cc> (raw)
In-Reply-To: <b2d2a2f154761904a98d14a73eb2d60e@sitening.com>
References: <2784476415a96bb0912ebca41edb3d84@sitening.com>
<6865.1113600214@sss.pgh.pa.us>
<b4a298793e5eee60fb12a725197d5c42@sitening.com>
<426C9508.8030902@sfnet.cc>
<02c5560a910870da3637b6ff791e3a80@sitening.com>
<426D265F.9080902@sfnet.cc>
<b2d2a2f154761904a98d14a73eb2d60e@sitening.com>
Tom,
Honestly, you've got me. It was either comment from Tom Lane or Josh
that the os is caching the results (I may not be using the right terms
here), so I thought it the database is dropped and recreated, I would
see less of a skew (or variation) in the results. Someone which to comment?
Steve Poe
Thomas F.O'Connell wrote:
> Considering the default vacuuming behavior, why would this be?
>
> -tfo
>
> --
> Thomas F. O'Connell
> Co-Founder, Information Architect
> Sitening, LLC
>
> Strategic Open Source: Open Your iâ„¢
>
> http://www.sitening.com/
> 110 30th Avenue North, Suite 6
> Nashville, TN 37203-6320
> 615-260-0005
>
> On Apr 25, 2005, at 12:18 PM, Steve Poe wrote:
>
>> Tom,
>>
>> Just a quick thought: after each run/sample of pgbench, I drop the
>> database and recreate it. When I don't my results become more skewed.
>>
>> Steve Poe
>
>
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: spoe@sfnet.cc, tfo@sitening.com
Subject: Re: pgbench Comparison of 7.4.7 to 8.0.2
In-Reply-To: <426E7F3A.8000500@sfnet.cc>
* 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