Offline dengan aplikasi Player FM !
Hash indexes
Manage episode 389665265 series 3369151
Nikolay and Michael discuss hash indexes in Postgres — what they are, some brief history, their pros and cons vs btrees, and whether or when they recommend using them.
Update: the idea Nikolay mentioned at the end of this episode turns out to be a little fraught (and as such, inadvisable).
Here are some links to things they mentioned:
- Index types (docs) https://www.postgresql.org/docs/current/indexes-types.html
- Re-introducing hash indexes in PostgreSQL (blog post by Haki Benita and Michael) https://hakibenita.com/postgresql-hash-index
- Hash indexes intro (docs) https://www.postgresql.org/docs/current/hash-intro.html
- Hash indexes implementation (docs) https://www.postgresql.org/docs/current/hash-implementation.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
119 episode
Manage episode 389665265 series 3369151
Nikolay and Michael discuss hash indexes in Postgres — what they are, some brief history, their pros and cons vs btrees, and whether or when they recommend using them.
Update: the idea Nikolay mentioned at the end of this episode turns out to be a little fraught (and as such, inadvisable).
Here are some links to things they mentioned:
- Index types (docs) https://www.postgresql.org/docs/current/indexes-types.html
- Re-introducing hash indexes in PostgreSQL (blog post by Haki Benita and Michael) https://hakibenita.com/postgresql-hash-index
- Hash indexes intro (docs) https://www.postgresql.org/docs/current/hash-intro.html
- Hash indexes implementation (docs) https://www.postgresql.org/docs/current/hash-implementation.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
119 episode
All episodes
×Selamat datang di Player FM!
Player FM memindai web untuk mencari podcast berkualitas tinggi untuk Anda nikmati saat ini. Ini adalah aplikasi podcast terbaik dan bekerja untuk Android, iPhone, dan web. Daftar untuk menyinkronkan langganan di seluruh perangkat.