News for hackers. Stuff that matters.
Re:Making PostgreSQL Scale Hadoop-style: Benchmark Numbers by mbubb on Friday October 31, 2014 @09:41PM (#8541928)
Instead of seeing this asa Hadoop alternative - this might be a better alternative to the clunky data warehousing options like Vertica, Netezza, Greenplum, etc.

The Citus vs Hadoop comparison feels a little apples vs oranges as presented.

I worked a bit with Netezza appliances which use an older version of postgres which can spread queries across a Bladecenter ... I wonder how this compares.

The downside of the Netezza (beside the huge cost) is that it is not expandable at all - to get more Netezza you need to buy another multirack system.

Also there is a bottleneck getting data in and out as there are individual host servers that you launch jobs through (ibm x3650s if I remember correctly).

Hadoop does a significantly better job than something like Netezza in those 2 areas.

I guess the head to head comparison would be Citus vs Impala/ Hbase? That is probably where a 'massively parallel' postgres setup that can scale horizontally would out perform its hadoop counterpart.

Re:Making PostgreSQL Scale Hadoop-style: Benchmark Numbers by twic on Saturday November 01, 2014 @07:38AM (#8542747)
I don't know much about the practical operation of this kind of software. What is it that makes Citus a better alternative to, say, Greenplum? Both of them are PostgreSQL-derived parallel column-store databases, right? What is Citus's USP?
Re:Making PostgreSQL Scale Hadoop-style: Benchmark Numbers by sitkack on Saturday November 01, 2014 @12:35AM (#8542196)
Netezza is fast. It solves many problems very well. It is expandable. How can it be free and expandable at the same time while also being blazingly fast?

Free hardware?