Skip to content
corpus.blog
Claim your blog
Record · corpus.blog/posts/01a0fd6a-5809-7175-a166-b4ab2b98f759

#PostgresMarathon 2-013: Why keep your index set lean

postgres.ai · published 10 November 2025

A record is what was published and who pointed at it. The text of the post is not held here: read it at the source, or at its Wayback capture.

Read the post at postgres.ai (opens in a new tab) Wayback capture (opens in a new tab)

0blogs citing

First cited
—
Most recent
—
Rank this month
not ranked
External links
13
Words captured
2,269

Cited by

No blog we hold has cited this post yet.

Links from this post

Link
Host
https://github.com/postgres/postgres/blob/fc295beb7b74d1f216a53cab61d22027121a763e/src/backend/executor/execIndexing.c
github.com
https://github.com/postgres/postgres/blob/fc295beb7b74d1f216a53cab61d22027121a763e/src/backend/access/heap/heapam.c
github.com
https://www.postgresql.org/docs/current/storage-hot.html
postgresql.org
https://www.percona.com/blog/benchmarking-postgresql-the-hidden-cost-of-over-indexing/
percona.com
https://medium.com/adyen/fighting-postgresql-write-amplification-with-hot-updates-c8090f329ad6
medium.com
https://github.com/postgres/postgres/blob/fc295beb7b74d1f216a53cab61d22027121a763e/src/backend/optimizer/path/indxpath.c
github.com
https://github.com/postgres/postgres/blob/fc295beb7b74d1f216a53cab61d22027121a763e/src/backend/optimizer/path/costsize.c
github.com
https://www.percona.com/blog/postgresql-indexes-can-hurt-you-negative-effects-and-the-costs-involved/
percona.com
The Unexpected Find That Freed 20GB of Unused Index Space Read at the source (opens in a new tab)
hakibenita.com
https://github.com/postgres/postgres/blob/fc295beb7b74d1f216a53cab61d22027121a763e/src/backend/storage/buffer/README
github.com
https://github.com/postgres/postgres/blob/fc295beb7b74d1f216a53cab61d22027121a763e/src/backend/access/heap/vacuumlazy.c
github.com
https://github.com/postgres/postgres/blob/fc295beb7b74d1f216a53cab61d22027121a763e/src/backend/access/nbtree/nbtinsert.c
github.com
https://github.com/postgres/postgres/blob/fc295beb7b74d1f216a53cab61d22027121a763e/src/include/access/nbtxlog.h
github.com
Elsewhere on postgres.ai (4)