BRIN indexes
Postgres FM
00:00
Correlation in Indexes and Hidden Column CTID
This chapter explores the concept of correlation in indexes and its impact on performance. It introduces the hidden column CTID and a trick to extract the page number from it, allowing users to check the physical storage aspects and determine the correlation. Examples using the CTID trick are provided.
Transcript
Play full episode
