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