Postgresql for OLAP

Question

Does anyone have experience of using postgresql for an OLAP setup, using cubes against the database etc. Having come across a number of idiosyncracies when using MySql for OLAP, are there reasons in favour of using postgresql instead (assuming that I want to go the open source route)?

Answer 1

There are a number of data warehousing software vendors that are based on Postgresql (and contribute OLAP related changes back to core fairly regularly). Check out http://www.greenplum.com/. I think you'll find that PG works a lot better (for nearly any workload, OLAP especially) than MySQL. Greenplum and other similar solutions should work a bit better than PG depending on your data sets and use cases.