Multi-column indexes | Postgres.FM 155 | #PostgreSQL #Postgres podcast

[ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!] Nik and Michael discuss multi-column indexes in Postgres — what they are, how to think about them, and some guidance around using them effectively. Here are some links to things they mentioned: Multicolumn Indexes (docs) https://www.postgresql.org/docs/curre... Our episode on Index-only scans https://postgres.fm/episodes/index-on... Combining Multiple Indexes (docs) https://www.postgresql.org/docs/curre... Enable BUFFERS with EXPLAIN ANALYZE by default https://git.postgresql.org/gitweb/?p=... “PostgreSQL includes an implementation of the standard btree […] The only limitation is that an index entry cannot exceed approximately one-third of a page” https://www.postgresql.org/docs/curre... Our episode on HOT updates https://postgres.fm/episodes/hot-updates Our episode on LIMIT vs Performance https://postgres.fm/episodes/limit-vs... ~~~ What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @postgresfm   / postgresfm  , @samokhvalov   / samokhvalov   and @michristofides   / michristofides   ~~~ Postgres FM is produced by: Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/ Michael Christofides, founder of pgMustard https://pgmustard.com/ ~~~ This is the video version. Check out https://postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.