Tomas Vondra

Bio

Tomas first met PostgreSQL in 2003 and quickly became a big fan. He participated in porting various applications to PostgreSQL from other databases, tuning and fixing performance issues etc. He is also a member of the executive committee of CSPUG (Czech and Slovak PostgreSQL Users Group), an "umbrella" organization for the local PostgreSQL community. Tomas currently works as a database engineer 2ndQuadrant, working on various PostgreSQL-related tasks.

Talk Description: Create statistics

One of the new features in PostgreSQL 10 was the ability to create multi-column statistics, helping the optimizer to understand dependencies between columns, produce more accurate estimates and hopefully better query plans. PostgreSQL 12 will enhance that by allowing additional more elaborate types of statistics, and more is likely coming in the future. In this talk I'll explain why we need this capability at all, how it works, which cases it already helps with, and what improvements are in the queue for future PostgreSQL versions.