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.