Hacker News Reader

Comment by lucian1900 | Hacker News Reader

lucian1900·

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.

View on HN

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

There is MonetDB: https://www.monetdb.org/

I use it with great success.

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

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.

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

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

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

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. :)

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.

Very cool! Thanks for contributing this.

Reply on news.ycombinator.com