Re: (Again) Column Store on PostGreSQL

Hi

pá 4. 1. 2019 v 17:12 odesílatel Simon AUBERT <aubert(dot)simon(at)gmail(dot)com>
napsal:

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

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
> aubert(dot)simon(at)gmail(dot)com
> +33 (0)6 66 28 52 04
>