Re: Any good olap benchmarks?

From: lst_hoe02(at)kwsoft(dot)de
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Any good olap benchmarks?
Date: 2010-03-31 13:19:24
Message-ID: 20100331151924.174773g693l639c0@webmail.kwsoft.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Zitat von Greg Smith <greg(at)2ndquadrant(dot)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???

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Gnanakumar 2010-03-31 13:22:53 Re: Statistics Collector not collecting server activities
Previous Message Brad Nicholson 2010-03-31 12:27:56 Re: Migrate postgres to newer hardware