pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Thomas F.O'Connell <tfo@sitening.com>
To: PgSQL - Performance <pgsql-performance@postgresql.org>
Subject: pgbench Comparison of 7.4.7 to 8.0.2
Date: Fri, 15 Apr 2005 16:02:29 -0500
Message-ID: <2784476415a96bb0912ebca41edb3d84@sitening.com> (raw)

I'm in the fortunate position of having a newly built database server 
that's pre-production. I'm about to run it through the ringer with some 
simulations of business data and logic, but I wanted to post the 
results of some preliminary pgbench marking.

http://www.sitening.com/pgbench.html

To me, it looks like basic transactional performance is modestly 
improved at 8.0 across a variety of metrics. I think this bodes well 
for more realistic loads, but I'll be curious to see the results of 
some of the simulations.

I've still got a little bit of preparatory time with this box, so I can 
continue to do some experimentation.

I'd be curious to see whether these numbers meet developer expectations 
and to see whether the developer and user community have insight into 
other pgbench options that would be useful to see.

Thanks!

-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



view thread (10+ messages)  latest in thread

Message-ID: <2784476415a96bb0912ebca41edb3d84@sitening.com>
Permalink:  ../2784476415a96bb0912ebca41edb3d84@sitening.com/
Also on:    postgresql.org/message-id/2784476415a96bb0912ebca41edb3d84@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
  Subject: Re: pgbench Comparison of 7.4.7 to 8.0.2
  In-Reply-To: <2784476415a96bb0912ebca41edb3d84@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