(Again) Column Store on PostGreSQL

From: Simon AUBERT <aubert(dot)simon(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: (Again) Column Store on PostGreSQL
Date: 2019-01-04 16:12:44
Message-ID: CANOsmnDz-hm-45f5XUeprXpU4nNEvdBGwBUU0TtuBOJkxH448w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

We can find this very informative blog post :
https://blog.2ndquadrant.com/column-store-plans/

And this wiki page :
https://wiki.postgresql.org/wiki/ColumnOrientedSTorage
I must say the approach with the "orientation" option is a genius idea.

I won't discuss much the advantages of COS, I had three years using Vertica
-I loved it-, some tests of Monetdb, and recently Column Store Index on
MSQL Server etc. And I'm pretty sure everybody is convinced this works
great for Instant Analytics with products such as Tableau or Spotfire.. and
much better than, saying, Hive. MonetDb is not so much enterprise ready
(not even paid support available), CH is young while PGSQL has proven its
high value in Transactionnal DB, the only thing missing for even a bigger
deployment is this feature.

From what I understand, there is a team at 2ndquadrant.com that works on it
(but I'm not sure it's still in the dev pipe).

My questions :
-do you develop from scratch or do you plan to use some code of
MonetDb/Clickhouse/C_Store_fdw for that? I don't know if even a
collaboration between teams is feasible (I may be very naive but that would
kick ass ^^)
.
-is it still in the pipe? do you have an idea of the workload or even ETA?

-I'm not a developer myself but I would be interested in testing,
benchmarking, etc.. how to get involved?

Best regards,

--
Simon AUBERT
aubert(dot)simon(at)gmail(dot)com
+33 (0)6 66 28 52 04

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-01-04 16:44:23 Re: Potentially undocumented behaviour change in Postgres 11 concerning OLD record in an after insert trigger
Previous Message Mark Jeffcoat 2019-01-04 16:02:54 Showing table comments with psql