/explore
|
You are here 
|
boringsql.com | ||
| | | | |
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. | |
| | | | |
nataliiadziubenko.com
|
|
| | | | | Recently, I had to quickly learn how to debug excessive spilling to disk on a Postgres instance. Information online on this topic is mostly scattered. I have a feeling that, whenever query plan analysis is involved, things always get a bit mystical. Since I'm going to forget it all tomorrow, it's good to write it down, both for others and for the future me... | |
| | | | |
hakibenita.com
|
|
| | | | | When it comes to database optimization, developers often reach for the same old tools: rewrite the query slightly differently, slap an index on a column, denormalize, analyze, vacuum, cluster, repeat. Conventional techniques are effective, but sometimes being creative can really pay off! | |
| | | | |
www.mathieupassenaud.fr
|
|
| | | |||
