From: lst_hoe02@kwsoft.de
To: pgsql-admin@postgresql.org
Subject: Re: Any good olap benchmarks?
Date: Wed, 31 Mar 2010 15:19:24 +0200
Message-ID: <20100331151924.174773g693l639c0@webmail.kwsoft.de> (raw)
In-Reply-To: <4BB32E2F.8030304@2ndquadrant.com>
References: <4BB32420.2080707@greenmice.info>
<4BB32E2F.8030304@2ndquadrant.com>
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???
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: lst_hoe02@kwsoft.de
Subject: Re: Any good olap benchmarks?
In-Reply-To: <20100331151924.174773g693l639c0@webmail.kwsoft.de>
* 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