- scalability vs efficiency vs. performance - OLAP vs. OLTP vs. HTAP - postgres v/ good at OLTP - middling for OLAP - OLAP issues - parallelism - efficiency - Issues with improving efficiency - very lowhanging fruits gone - Amdahls Law - Bad news: - batch tuple processing - Good news: - bitmapscan improvements - hash-agg improvements - transition value computation improvements - expression evaluation - faster interpretation - tuple deforming - oops 1-3% - So, how to improve further - JIT compilation - what does JIT compliation mean Future News: - smarter JIT evaluation: - inline functions - batch tuple processing #2 - buffer management