Published:
[Erscheinungsort nicht ermittelbar]: PGCon - PostgreSQL Conference for Users and Developers, 2020
Published in:PGCon 2020 ; (Jan. 2020)
Extent:
1 Online-Ressource (81 MB, 00:48:48:08)
Language:
English
DOI:
10.5446/52129
Identifier:
Origination:
Footnote:
Audiovisuelles Material
Description:
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