News for hackers. Stuff that matters.
Re:PostgreSQL Columnar Store for Analytic Workloads by lucian1900 on Thursday April 03, 2014 @01:00PM (#7524193)
This is potentially very interesting, it's the only open source SQL columnar store I'm aware of. Bonus points for being part of Postgres.

Basically ParAccel (like used by Amazon RedShift) at reasonable cost.

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.

Re:PostgreSQL Columnar Store for Analytic Workloads by rhelmer on Thursday April 03, 2014 @10:58PM (#7528916)
Very cool! Thanks for contributing this.