Zitat von Greg Smith <greg@xxxxxxxxxxxxxxx>:
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???
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
