Multi-column indexes

Postgres FM

Konten disediakan oleh Michael Christofides and Nikolay Samokhvalov. Semua konten podcast termasuk episode, grafik, dan deskripsi podcast diunggah dan disediakan langsung oleh Michael Christofides and Nikolay Samokhvalov atau mitra platform podcast mereka. Jika Anda yakin seseorang menggunakan karya berhak cipta Anda tanpa izin, Anda dapat mengikuti proses yang diuraikan di sini https://id.player.fm/legal.

4M ago 41:21

MP3•Beranda episode

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/current/indexes-multicolumn.html
Our episode on Index-only scans https://postgres.fm/episodes/index-only-scans
Combining Multiple Indexes (docs) https://www.postgresql.org/docs/current/indexes-bitmap-scans.html
Enable BUFFERS with EXPLAIN ANALYZE by default https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=c2a4078ebad71999dd451ae7d4358be3c9290b07
“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/current/btree.html
Our episode on HOT updates https://postgres.fm/episodes/hot-updates
Our episode on LIMIT vs Performance https://postgres.fm/episodes/limit-vs-performance

~~~

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 produced by:

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

With credit to:

Jessie Draws for the elephant artwork

166 episode

#Tech #News #Tech News #Michael Christofides #Nikolay Samokhvalov #Postgres #PostgreSQL #Database #SQL #Technology