TLDR Dev · QUICK LINKS
PRODUCTION QUERY PLANS WITHOUT PRODUCTION DATA
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.