Re:PostgreSQL Columnar Store for Analytic Workloads
by alecco on Thursday April 03, 2014 @02:11PM
(#7524800)
InfinyDB did this with MySQL a long time ago http://infinidb.co/products
Re:PostgreSQL Columnar Store for Analytic Workloads
by lneves on Friday April 04, 2014 @05:21AM
(#7530186)
There is MonetDB: https://www.monetdb.org/
I use it with great success.
Re:PostgreSQL Columnar Store for Analytic Workloads
by erichocean on Friday April 04, 2014 @10:06AM
(#7531469)
And it's been around forever. If you're interested in high-speed processing, there's lots of good papers from that project (e.g. how to avoid creating branches, stuff like that).
Re:PostgreSQL Columnar Store for Analytic Workloads
by paperwork on Thursday April 03, 2014 @01:16PM
(#7524360)
I agree, I'm excited. Hopefully the optimizer can take full advantage of these column stores.
However, postgresql isn't the only open source column store. MonetDB is another one. It is an academic project but people do use it commercially. I know some people who get great performance out of MonetDB, even though its optimizer has some gaps.
Re:PostgreSQL Columnar Store for Analytic Workloads
by alexatkeplar on Thursday April 03, 2014 @05:06PM
(#7526673)
https://www.infobright.org/ has been around for ages.
Re:PostgreSQL Columnar Store for Analytic Workloads
by jerven on Friday April 04, 2014 @12:50AM
(#7529377)
Virtioso 7 by openlinksw is a GPL columnar sql (and sparql) RDBMS
Re:PostgreSQL Columnar Store for Analytic Workloads
by rhelmer on Thursday April 03, 2014 @01:38PM
(#7524542)
Don't you still need to purchase citus DB to use this?
Re:PostgreSQL Columnar Store for Analytic Workloads
by ozgune on Thursday April 03, 2014 @01:45PM
(#7524601)
Nope, you don't need to purchase CitusDB.
We open sourced cstore_fdw with the Apache license. You can just build and load the extension, and start using it with your PostgreSQL 9.3+ database.
If you later need to scale out your PostgreSQL cluster, just please let us know. :)
Re:PostgreSQL Columnar Store for Analytic Workloads
by spaznode on Thursday April 03, 2014 @09:49PM
(#7528596)
I know some statisticians / analyst minded people your generous contribution may make extremely happy. Myself as well of course.
Thank you very very much in advance. This is a really huge deal. Even for general things like academic research. We shall see.
Basically ParAccel (like used by Amazon RedShift) at reasonable cost.