News for hackers. Stuff that matters.

A comment on PostgreSQL vs. Impala.

Re:PostgreSQL vs. Impala by ecolak on Tuesday March 11, 2014 @01:06PM (#7380590)
Impala, imitating Google's Dremel, is specifically designed for OLAP scenarios with its columnar storage structure and the compression algorithms that go along with it. This is not a fair comparison. Try doing OLTP with Impala and you'll see what I mean.
[ Parent | on HN ]
Re:PostgreSQL vs. Impala by dagilmore on Wednesday March 12, 2014 @10:52PM (#7389819)
Great point! I mentioned it in the post, did you read it?

"Note that the properties of a relational database are well suited to online-transaction processing (OLTP). Such a system guarantees consistency and availability, and it supports extreme multi-tenancy. However, complex logic over large amounts of data does not perform well"

[ Parent | on HN ]