TLDR Dev · QUICK LINKS

PRODUCTION QUERY PLANS WITHOUT PRODUCTION DATA

boringsql.com10 min read

Summary from the TLDR Dev newsletter

PostgreSQL 18 introduces new functions and `pg_dump --statistics-only` to export and inject production optimizer statistics into non-production databases, enabling accurate reproduction and testing of production query plans without needing the actual data.