Over-indexing | Postgres FM | Episode 68 (opens in new tab)

Nikolay and Michael discuss over-indexing — what we mean by it, the regular issues people discuss about it, as well as a novel one Nikolay has come across and benchmarked recently. Here are some links to things they mentioned:Nikolay’s tweet on over-indexing Heap-Only Tuples (HOT) optimization Our episode on index maintenance PgBouncer now supports prepared statements Our episode on connection poolers Configurable FP_LOCK_SLOTS_PER_BACKEND (Hackers mailing list discussion) LWLock:lock_manager...