BRIN indexes
Postgres FM
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.
00:00
Transcript
Play full episode
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
