pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAny good olap benchmarks?
3+ messages / 3 participants
[nested] [flat]
* Any good olap benchmarks?
@ 2010-03-31 10:29 Vladimir Rusinov <vladimir@greenmice.info>
0 siblings, 1 reply; 3+ messages in thread
From: Vladimir Rusinov @ 2010-03-31 10:29 UTC (permalink / raw)
To: pgsql-admin
Hi!
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've found DBT-3 benchmark, but it lacks documentation and I have no
idea how to run in over network (I need server and client to be on
different hosts).
--
Vladimir Rusinov
Google Profile: http://www.google.com/profiles/vladimir.rusinov
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Any good olap benchmarks?
@ 2010-03-31 11:12 Greg Smith <greg@2ndquadrant.com>
parent: Vladimir Rusinov <vladimir@greenmice.info>
0 siblings, 1 reply; 3+ messages in thread
From: Greg Smith @ 2010-03-31 11:12 UTC (permalink / raw)
To: Vladimir Rusinov <vladimir@greenmice.info>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Any good olap benchmarks?
@ 2010-03-31 13:19 lst_hoe02@kwsoft.de
parent: Greg Smith <greg@2ndquadrant.com>
0 siblings, 0 replies; 3+ messages in thread
From: lst_hoe02@kwsoft.de @ 2010-03-31 13:19 UTC (permalink / raw)
To: pgsql-admin
Zitat von Greg Smith <greg@2ndquadrant.com>:
> 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.
I maybe wrong but this looks like "partitioning" PostgreSQL to me???
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-03-31 13:19 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-03-31 10:29 Any good olap benchmarks? Vladimir Rusinov <vladimir@greenmice.info>
2010-03-31 11:12 ` Greg Smith <greg@2ndquadrant.com>
2010-03-31 13:19 ` lst_hoe02@kwsoft.de
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