Schedule - pgDay Paris 2020

CREATE STATISTICS - what is it about?

Date: 2020-03-26
Time: 15:55–16:40
Room: Auditorium

One of the new features in PostgreSQL 10 is the ability to create multi-column statistics, helping the optimizer understand dependencies between columns. PostgreSQL 12 further improved the feature by supporting more complicated statistics types.

This talk will explain a bunch of important questions - why we need this capability at all for some queries, how it works, which cases it can address currently, and which improvements are in the queue for PostgreSQL 13.


Tomas Vondra