Andrei Lepikhov
Database systems engineer and PostgreSQL contributor since 2017. At pgEdge I work on active-active logical replication; as a contributor my own subject is the query planner and executor.
Two tracks, not one. Replication is the day job. The planner work — self-join removal, GROUP BY ordering, cardinality estimation, pre-sorted paths — is what I take to pgsql-hackers, and what most of the extensions and papers here are about.
Ph.D. on query processing in parallel database systems for hierarchically organized multiprocessors, then eight years at Postgres Professional, latterly heading its query optimization lab. For eight years before that, and overlapping it, I was a senior scientist computing supersonic and hypersonic flows around re-entry vehicles — heat loads, ablating thermal protection, rocket engine combustion.
I write about Postgres internals at danolivo.substack.com.
What I am working on
- DBMS Digest — a weekly, ad-free, fact-checked roundup of what actually happened in databases
- Spock — active-active logical replication across PostgreSQL clusters
- pg_track_optimizer — finds queries the planner got wrong, before they become an incident
- pg_middleout — a top-down planning pass that memoizes correlated subplans
- pg_index_stats — derives extended statistics automatically from the indexes you already have
- Try a presorted outer path when referenced by an ORDER BY prefix — sort the outer side of a join so nothing has to be sorted above it (in flight)
What has shipped is on the projects page, with the release each feature landed in; what is still open upstream is in flight.
Recent talks
- pg_track_optimizer: finding query planning issues before they impact performance. PG BootCamp Russia 2026, Moscow, 19 March 2026. slides
- pg_index_stats: managing extended statistics automatically. FOSSASIA Summit 2024, PGDay track, Hanoi, Vietnam, 8–10 April 2024. slides
- Does PostgreSQL respond to the challenge of analytical queries? PGDay Israel 2024, Tel Aviv, 20 October 2024. slides
Full list of talks and publications.