
Why Postgres is slow on OLAP queries?
1. Unpacking tuple overhead (heap_deform_tuple)
2. Interpretation overhead (invocation of query plan node
functions)
3. Abstraction penalty (user defined types and operations)
4. Pull model overhead (saving/restoring context on each
access to the page)
5. MVCC overhead (~20 bytes per tuple space overhead +
visibility check overhead)
评论