Generating Production Query Plans Without Production Data in PostgreSQL 18

Simon Willison highlights new functions in PostgreSQL 18, `pg_restore_relation_stats()` and `pg_restore_attribute_stats()`, which allow for the creation of production query plans without relying on sensitive production data. This enhancement aims to improve database performance analysis and security.

Source: Simon Willison Blog