Message-ID: <4BB32E2F.8030304@2ndquadrant.com>
Date: Wed, 31 Mar 2010 07:12:47 -0400
From: Greg Smith <greg@2ndquadrant.com>
User-Agent: Thunderbird 2.0.0.24 (X11/20100317)
MIME-Version: 1.0
To: Vladimir Rusinov <vladimir@greenmice.info>
CC: pgsql-admin@postgresql.org
Subject: Re: Any good olap benchmarks?
References: <4BB32420.2080707@greenmice.info>
In-Reply-To: <4BB32420.2080707@greenmice.info>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Vladimir Rusinov wrote:
> I'm searching for any good OLAP-like benchmark: I need some benchmark
> with complex selects run on 10-30G dataset, something like this:
> http://www.percona.com/docs/wiki/benchmark:wikistat:start, but this is
> only a draft and would only be released for mysql.
>   

I already intended to convert and run Vadim's Wikipedia statistics 
benchmark when I get to it; as we're busy getting the next PostgreSQL 
release out the door right now I just haven't gotten to it yet.  I 
expect we can get that added into their mix on the same hardware once 
I'm done.

I've linked to everything I'm aware of at 
http://wiki.postgresql.org/wiki/Category:Benchmarking and the TPC-H page 
has probably the most relevant information for OLAP.  PostgreSQL doesn't 
do particularly well on OLAP benchmarks yet due to how queries are 
limited by a single processor, making it hard to get excited about 
publishing the results.

Greenplum ran some interesting tests of their own software against 
PostgreSQL at http://community.greenplum.com/showthread.php?t=113 you 
might find interesting.  That includes a fairly easy to use TPC-H like 
test kit program, and by showing where they did much better is suggest 
the areas that community Postgres struggles relative to software that 
handles parallel query across multiple cores/servers. 

-- 
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us