About
Andrei works in the query optimisation and execution area of PostgreSQL, with a particular interest in adaptive methods of query planning and execution. He has designed two distributed PostgreSQL-based systems — Shardman and Multimaster — and has been contributing to the PostgreSQL core since 2017. He holds a PhD in Computer Science, specialising in distributed databases (2008).
Andrei Lepikhov has presented the following presentations
Teaching PostgreSQL to scan temporary tables in parallel
at
PG Down Under 2026
Why Your Temp Table Kills Parallelism and How We Fixed It
presented by Andrei Lepikhov
Ever since PostgreSQL gained parallel query in 9.6, it has unconditionally refused to parallelise any part of a plan that touches a temporary table. The reason is structural: temporary-table pages live in the leader's local buffers, which parallel workers cannot see, so the planner simply marks such scans parallel-restricted.
As parallel execution has matured — partial aggregation, parallel ...
more Development