From: Josh Berkus <josh@agliodbs.com>
Reply-To: josh@agliodbs.com
Organization: Aglio Database Solutions
To: pgsql-performance@postgresql.org
Subject: Re: Benchmarking PGSQL?
Date: Wed, 14 Feb 2007 15:42:55 -0800
User-Agent: KMail/1.8
Cc: "Krishna Kumar" <kumar.ramanathan@gmail.com>
References: <eed7b2c20702140200v3d6ea5f6jec466f95dd6f8012@mail.gmail.com>
In-Reply-To: <eed7b2c20702140200v3d6ea5f6jec466f95dd6f8012@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200702141542.55562.josh@agliodbs.com>

Krisna,

> I'm a performance engineer, quite interested in getting deep into the
> PGSQL performance enhancement effort. In that regard, I have the
> following questions :
> 1. Is there a benchmarking setup, that I can access online?
> 2. What benchmarks are we running , for performance numbers?
> 3. What are the current issues, related to performance?
> 4. Where can I start, with the PGSQL performance effort?

Hey, I work for Sun and we've been working on PostgreSQL & benchmarks.   
Hopefully we will soon have a server which runs Spec benchmarks which the 
community can legally use for testing (it's waiting on some setup issues).

Help we could use right now includes work on an open source TPCE-like 
workload, being run by Rilson and Mark Wong.   Another issue which could 
use help is reducing our WAL transaction log volume; it's higher than any 
other database.   Or you could work on multi-processor scalability; we are 
still trying to identify the bottlenecks which are holding us back there.

-- 
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco