Tomas Vondra, PostgreSQL Database Engineer at 2ndQuadrant, presented a webinar on CREATE STATISTICS command in PostgreSQL. The command was initially introduced in PostgreSQL 10 and saw further improvements in PostgreSQL 12. This command allows the database to collect multi-column statistics which helps the optimizer understand dependencies between columns, produces more accurate estimates and results in the formation of better query plans.
The webinar “All you need to know about CREATE STATISTICS” was held on 26 Feb 2020 and covered the following topics:
- Why CREATE STATISTICS is needed
- How the command helps the optimizer and in query planning
- Which cases CREATE STATISTICS addresses
- What improvements related to CREATE STATISTICS are in store for future PostgreSQL versions
Those who weren’t able to attend the live webinar can now view the recording here.
To stay updated on upcoming webinars by 2ndQuadrant, you can visit our Webinars page.
For any questions, comments, or feedback, please visit our website or send an email to webinar@2ndquadrant.com.