From: Greg Smith <greg@2ndquadrant.com>
To: Vladimir Rusinov <vladimir@greenmice.info>
Cc: pgsql-admin@postgresql.org
Subject: Re: Any good olap benchmarks?
Date: Wed, 31 Mar 2010 07:12:47 -0400
Message-ID: <4BB32E2F.8030304@2ndquadrant.com> (raw)
In-Reply-To: <4BB32420.2080707@greenmice.info>
References: <4BB32420.2080707@greenmice.info>
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
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-admin@postgresql.org
Cc: greg@2ndquadrant.com, vladimir@greenmice.info
Subject: Re: Any good olap benchmarks?
In-Reply-To: <4BB32E2F.8030304@2ndquadrant.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