4

It looks like there is a (finally) an open source columnar and compression extension for Postgres.

I wonder if anyone had any experience with it yet?

I've worked with Greenplum for years, but I've been looking desperately for the open source alternative.

closed as primarily opinion-based by RolandoMySQLDBA, Paul White, dezso, Mikael Eriksson, datagod Jan 27 '15 at 14:18

Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    Given how new it is, and how slow-moving the kinds of organisations that want column stores often are, you'll probably be in the forefront of people looking to apply it to real world uses. – Craig Ringer May 28 '14 at 6:36
2

you get an impression of the performance looking at the comparison with a real column store: https://www.monetdb.org/content/citusdb-postgresql-column-store-vs-monetdb-tpc-h-shootout

Not the answer you're looking for? Browse other questions tagged or ask your own question.