News for hackers. Stuff that matters.
Re:Making PostgreSQL Scale Hadoop-style: Benchmark Numbers by ddorian43 on Friday October 31, 2014 @01:30PM (#8539955)
Re:Making PostgreSQL Scale Hadoop-style: Benchmark Numbers by ozgune on Friday October 31, 2014 @02:35PM (#8540323)
(Ozgun from Citus Data)

This benchmark confuses CitusDB with PostgreSQL + cstore_fdw extension. CitusDB scales out PostgreSQL to multiple machines, and cstore is a columnar store for PostgreSQL. The author has a clarification posted at the end.

For single node Postgres + cstore numbers on TPC-H, we found that a few simple changes notably help. 1/ Analyze on foreign tables + increasing work_mem helps join queries by 2-4x, and 2/ Using the double precision instead of the numeric type increases aggregate function performance by 6x.

Lastly, we agree that vectorized execution can result in notable performance wins! See https://github.com/citusdata/postgres_vectorization_test for some initial work. We hope to incorporate some of MonetDB's vectorized execution features in cstore_fdw in the future.