News for hackers. Stuff that matters.
Re:Making PostgreSQL Scale Hadoop-style: Benchmark Numbers by gopalv on Friday October 31, 2014 @01:42PM (#8540029)
Neat. Postgres has always had a kick-ass I/O layer - particularly on ext4.

I think showing Q2 and Q11 numbers would've been great, because for something like Tez, this is how those plans look in Hive (before the cost-based optimizer work)

http://people.apache.org/~gopalv/tpch-plans/q2_minimum_cost_...

http://people.apache.org/~gopalv/tpch-plans/q11_important_st...

Postgres's query planner should shine for those.

Re:Making PostgreSQL Scale Hadoop-style: Benchmark Numbers by getsat on Friday October 31, 2014 @04:43PM (#8541025)
You've seen better performance on ext4 than XFS? The opposite has been my experience (mainly on 1tb data across 100 million rows, 20,000 queries/sec). btrfs + compression was 5x faster than XFS, but btrfs has nasty kernel deadlock bugs when the disk is almost full.