Radim @ boringSQL on Mythryl: “What happens when you inject production statistics into a 10,000-row…”

What happens when you inject production statistics into a 10,000-row PostgreSQL test table? The query plan flips.   PostgreSQL 18 makes this a one-liner. pg_dump --statistics-only  Plain SQL, under 1MB, no data needed. Learn the mechanics in my latest blog post.   boringsql.com/posts/portab...

boringsql.comProduction query plans without production dataPostgreSQL 18 makes optimizer statistics portable. Export them from production and inject them into test databases to get realistic query plans without the data.

9/3/26, 8:44 am0 reposts2 likes