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
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