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