(Again) Column Store on PostGreSQL

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

(Again) Column Store on PostGreSQL

Simon AUBERT
Hello,

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

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
[hidden email]
+33 (0)6 66 28 52 04
Reply | Threaded
Open this post in threaded view
|

Re: (Again) Column Store on PostGreSQL

legrand legrand
Reply | Threaded
Open this post in threaded view
|

Re: (Again) Column Store on PostGreSQL

Pavel Stehule
In reply to this post by Simon AUBERT
Hi

pá 4. 1. 2019 v 17:12 odesílatel Simon AUBERT <[hidden email]> napsal:
Hello,

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

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 ^^)

 With high probability the code should be written from scratch - every database has lot of unique features, code base, memory management, optimizer, .. It is hard, almost impossible to reuse some code from other database. 

Regards

Pavel

.
-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
[hidden email]
+33 (0)6 66 28 52 04
Reply | Threaded
Open this post in threaded view
|

Re: (Again) Column Store on PostGreSQL

Simon AUBERT
Thanks Pavel and Pascal.

I guess I was really optimistic about an early implementation ^^


Best regards,

Simon

Le ven. 4 janv. 2019 à 18:35, Pavel Stehule <[hidden email]> a écrit :
Hi

pá 4. 1. 2019 v 17:12 odesílatel Simon AUBERT <[hidden email]> napsal:
Hello,

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

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 ^^)

 With high probability the code should be written from scratch - every database has lot of unique features, code base, memory management, optimizer, .. It is hard, almost impossible to reuse some code from other database. 

Regards

Pavel

.
-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
[hidden email]
+33 (0)6 66 28 52 04


--
Simon AUBERT
[hidden email]
+33 (0)6 66 28 52 04