How PostgreSQL Uses B-Tree Indexes to Retrieve Data from Disk
Tracing how PostgreSQL traverses B-Tree indexes, resolves Tuple Identifiers (TIDs), fetches heap pages, and eventually turns a SQL query into disk reads.
Tracing how PostgreSQL traverses B-Tree indexes, resolves Tuple Identifiers (TIDs), fetches heap pages, and eventually turns a SQL query into disk reads.