pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Thomas F.O'Connell <tfo@sitening.com>
To: Steve Poe <spoe@sfnet.cc>
Cc: PgSQL - Performance <pgsql-performance@postgresql.org>
Subject: Re: pgbench Comparison of 7.4.7 to 8.0.2
Date: Sat, 23 Apr 2005 21:33:00 -0500
Message-ID: <a7d01e3672a76f528ac59207627ce69f@sitening.com> (raw)
In-Reply-To: <42603127.5070108@sfnet.cc>
References: <2784476415a96bb0912ebca41edb3d84@sitening.com>
	<42603127.5070108@sfnet.cc>

Steve,

Per your and Tom's recommendations, I significantly increased the 
number of transactions used for testing. See my last post.

The database will have pretty heavy mixed use, i.e., both reads and 
writes.

I performed 32 iterations per scenario this go-round.

I'll look into OSDB for further benchmarking. Thanks for the tip.

Since pgbench is part of the postgres distribution and I had it at hand 
and it seems to be somewhat widely referenced, I figured I go ahead and 
post preliminary results from it.

-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 15, 2005, at 4:24 PM, Steve Poe wrote:

> Tom,
>
> People's opinions on pgbench may vary, so take what I say with a grain 
> of salt. Here are my thoughts:
>
> 1) Test with no less than 200 transactions per client. I've heard with 
> less than this, your results will vary too much with the direction of 
> the wind blowing. A high enough value will help rule out some "noise" 
> factor. If I am wrong, please let me know.
>
>
> 2) How is the database going to  be used?  What percentage will be 
> read/write if you had to guess? Pgbench is like a TPC-B with will help 
> guage the potential throughput of your tps. However, it may not stress 
> the server enough to help you make key performance changes. However, 
> benchmarks are like statistics...full of lies <g>.
>
> 3) Run not just a couple pgbench runs, but *many* (I do between 20-40 
> runs) so you can rule out noise and guage improvement on median 
> results.
>
> 4) Find something that you test OLTP-type transactions. I used OSDB 
> since it is simple to implement and use. Although OSDL's OLTP testing 
> will closer to reality.
>
> Steve Poe




view thread (10+ messages)  latest in thread

Message-ID: <a7d01e3672a76f528ac59207627ce69f@sitening.com>
Permalink:  ../a7d01e3672a76f528ac59207627ce69f@sitening.com/
Also on:    postgresql.org/message-id/a7d01e3672a76f528ac59207627ce69f@sitening.com

 · 

reply

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: tfo@sitening.com, spoe@sfnet.cc
  Subject: Re: pgbench Comparison of 7.4.7 to 8.0.2
  In-Reply-To: <a7d01e3672a76f528ac59207627ce69f@sitening.com>

* 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