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 https://twitter.com/samokhvalov/status/1713101666629927112
Heap-Only Tuples (HOT) optimization https://www.postgresql.org/docs/current/storage-hot.html
Our episode on index maintenance https://postgres.fm/episodes/index-maintenance
PgBouncer now supports prepared statements https://github.com/pgbouncer/pgbouncer/releases/tag/pgbouncer_1_21_0
Our episode on connection poolers https://postgres.fm/episodes/connection-poolers
Configurable FP_LOCK_SLOTS_PER_BACKEND (Hackers mailing list discussion) https://www.postgresql.org/message-id/flat/CAM527d-uDn5osa6QPKxHAC6srOfBH3M8iXUM%3DewqHV6n%3Dw1u8Q%40mail.gmail.com
LWLock:lock_manager (Amazon RDS docs) https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/wait-event.lw-lock-manager.html

~~~

What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!

~~~

Postgres FM is brought to you by:

Nikolay Samokhvalov, founder of Postgres.ai
Michael Christofides, founder of pgMustard

With special thanks to:

Jessie Draws for the amazing artwork

Episode 7: Ask Me Anything LADY BOSS Edition: Building a Personal Brand, Balancing Your Business With a Full-Time Job, Staying Inspired, and Doing Your Personal Best