3 ms·
> Why would some random software be able to make my pg 8 times faster or more? Peter Boncz (creator of VectorWise, HyPer) says it best here: http://www.tpc.org
by quizotic 11y ago
> Why would some random software be able to make my pg 8 times faster or more?
Peter Boncz (creator of VectorWise, HyPer) says it best here:
http://www.tpc.org/tpctc/tpctc2013/slides_and_papers/005.pdf http://www.tpc.org/tpctc/tpctc2013/slides_and_papers/005.pdf
Remember also that the postgres planner and execution machinery is ANCIENT. Plan scoring still assumes Disk I/O = 10 MemoryAccess = 100CPU instructions. Modern CPUs are SIMD and Vector processing, but PG planning/exec machinery isn't vector aware. There's a 200X difference between L1 cache and main memory access that the PG planner can't see. And what about SSDs and NVMe vs disk? Spark gains its speed through caching intermediate result sets along with the ability to reconstruct them. But postgres doesn't cache intermediate results or query plans last I checked. Plus a million other things.
Postgres is wonderful, but not because it has natively fast analytics. 8X is nothing. 180X is better, but not as fast as Vertica, Aster, Greenplum, et al. I say kudos to Citus and Vitesse for leading the way.