Skip site navigation (1) Skip section navigation (2)

Re: Open request for benchmarking input

From: Ron <rjpeace(at)earthlink(dot)net>
To: "Luke Lonergan" <llonergan(at)greenplum(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Open request for benchmarking input
Date: 2005-11-26 20:31:33
Message-ID: 6.2.5.6.0.20051126152139.01d97350@earthlink.net (view raw or flat)
Thread:
Lists: pgsql-performance
At 03:15 PM 11/26/2005, Luke Lonergan wrote:

>I suggest specifying a set of basic system / HW benchmarks to baseline the
>hardware before each benchmark is run.  This has proven to be a major issue
>with most performance tests.  My pick for I/O is bonnie++.
>
>Your equipment allows you the opportunity to benchmark all 5 machines
>running together as a cluster - this is important to measure maturity of
>solutions for high performance warehousing.  Greenplum can provide you a
>license for Bizgres MPP for this purpose.
...and detailed config / tuning specs as well for it or everyone is 
probably wasting their time.  For instance, it seems fairly clear 
that the default 8KB table size and default read ahead size are both 
pessimal, at least for non OLTP-like apps.  In addition, there's been 
a reasonable amount of evidence that xfs should be the file system of 
choice for pg.

Things like optimal RAID strip size, how to allocate tables to 
various IO HW, and what levels of RAID to use for each RAID set also 
have to be defined.


>The 16x SATA drives should be great, provided you have a high performance
>RAID adapter configured properly.  You should be able to get 800MB/s of
>sequential scan performance by using a card like the 3Ware 9550SX.  I've
>also heard that the Areca cards are good (how good?).  Configuration of the
>I/O must be validated though - I've seen as low as 25MB/s from a
>misconfigured system.
The Areca cards, particularly with 1-2GB of buffer cache, are the 
current commodity RAID controller performance leader.  Better 
performance can be gotten out of HW from vendors like Xyratex, but it 
will cost much more.


Ron



In response to

pgsql-performance by date

Next:From: Andreas PflugDate: 2005-11-27 00:12:01
Subject: Re: Open request for benchmarking input
Previous:From: Luke LonerganDate: 2005-11-26 20:15:28
Subject: Re: Open request for benchmarking input

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group