/explore
|
You are here 
|
www.mikejohnson.dev | ||
| | | | |
abuisman.com
|
|
| | | | | Blog about solving problems with code, mostly Ruby, and other things I have learned working as an engineer and a technical leader | |
| | | | |
postgrespro.com
|
|
| | | | | In previous articles we discussed query execution stages and statistics . Last time, I started on data access methods, namely Sequential scan . Today we will cover Index Scan. This article requires a basic understanding of the index method interface. If words like "operator class" and "access method properties" don't ring a bell, check out my article on indexes from a while back for a refresher. Plain Index Scan Indexes return row version IDs (tuple IDs, or TIDs for short), which can be handled in one of... | |
| | | | |
www.crunchydata.com
|
|
| | | | | What is a sequential scan vs index scan vs parallel scan .... and what is a bitmap heap scan? Postgres scan types explained and diagrammed. | |
| | | | |
www.crunchydata.com
|
|
| | | Adding extended statistics can add information about how columns are related. Louise has some real life example queries and tips for working with extended table stats that can dramatically improve query performance. | ||
