From: Luke Lonergan <llonergan@greenplum.com>
To: Krishna Kumar <kumar.ramanathan@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: Benchmarking PGSQL?
Date: Wed, 14 Feb 2007 07:35:43 -0800
Message-ID: <C1F86C4F.27217%llonergan@greenplum.com> (raw)
In-Reply-To: <eed7b2c20702140200v3d6ea5f6jec466f95dd6f8012@mail.gmail.com>
Here¹s one:
Insert performance is limited to about 10-12 MB/s no matter how fast the
underlying I/O hardware. Bypassing the WAL (write ahead log) only boosts
this to perhaps 20 MB/s. We¹ve found that the biggest time consumer in the
profile is the collection of routines that ³convert to datum².
You can perform the test using any dataset, you might consider using the
TPC-H benchmark kit with a data generator available at www.tpc.org. Just
generate some data, load the schema, then perform some COPY statements,
INSERT INTO SELECT FROM and CREATE TABLE AS SELECT.
- Luke
On 2/14/07 2:00 AM, "Krishna Kumar" <kumar.ramanathan@gmail.com> wrote:
> Hello All,
> 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?
>
> Thanks a lot,
> Krishna
>
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: llonergan@greenplum.com, kumar.ramanathan@gmail.com
Subject: Re: Benchmarking PGSQL?
In-Reply-To: <C1F86C4F.27217%llonergan@greenplum.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