4 ms·

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 (l

by lucian1900 13y ago

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.

paperwork 13y ago
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.
rhelmer 13y ago
Don't you still need to purchase citus DB to use this?
- ozgune 13y ago
  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. :)
  - spaznode 13y ago
    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.
  - rhelmer 13y ago
    Very cool! Thanks for contributing this.
- deleted 13y ago
  [deleted]
alecco 13y ago
InfinyDB did this with MySQL a long time ago http://infinidb.co/products http://infinidb.co/products
alexatkeplar 13y ago
https://www.infobright.org/ https://www.infobright.org/ has been around for ages.
lneves 13y ago
There is MonetDB: https://www.monetdb.org/ https://www.monetdb.org/ I use it with great success.
- erichocean 13y ago
  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).
jerven 13y ago
Virtioso 7 by openlinksw is a GPL columnar sql (and sparql) RDBMS

paperwork 13y ago

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.

rhelmer 13y ago

Don't you still need to purchase citus DB to use this?

ozgune 13y ago
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. :)
- spaznode 13y ago
  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.
- rhelmer 13y ago
  Very cool! Thanks for contributing this.
deleted 13y ago
[deleted]

alecco 13y ago

InfinyDB did this with MySQL a long time ago http://infinidb.co/products http://infinidb.co/products

alexatkeplar 13y ago

https://www.infobright.org/ https://www.infobright.org/ has been around for ages.

lneves 13y ago

There is MonetDB: https://www.monetdb.org/ https://www.monetdb.org/ I use it with great success.

erichocean 13y ago
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).

jerven 13y ago

Virtioso 7 by openlinksw is a GPL columnar sql (and sparql) RDBMS