PostgreSQL 18 beta has been released, and it’s the perfect time to start exploring the new features we can expect in the General Availability (GA) release. One feature that particularly caught my attention relates to improvements in statistics collection and usage. Here’s an excerpt from the official PostgreSQL release notes:
Add functions to modify per-relation and per-column optimizer statistics (Corey Huinker) Add pg_dump, pg_dumpall, and pg_restore options –statistics-only, –no-statistics, –no-data, and –no-schema (Corey Huinker, Jeff Davis)
One of the key ingredients in performance analysis is understanding the underlying statistics of tables, columns, and indexes. Often, we encounter cases where queries behave differently in production compared to Pre-Prod or UAT environments. A common reason for this discrepancy…
External feed Read More at the Source: https://postgr.es/p/773