Multi-column indexes

Postgres FM

Contenido proporcionado por Michael Christofides and Nikolay Samokhvalov. Todo el contenido del podcast, incluidos episodios, gráficos y descripciones de podcast, lo carga y proporciona directamente Michael Christofides and Nikolay Samokhvalov o su socio de plataforma de podcast. Si cree que alguien está utilizando su trabajo protegido por derechos de autor sin su permiso, puede seguir el proceso descrito aquí https://es.player.fm/legal.

4M ago 41:21

MP3•Episodio en casa

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

167 episodios

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