all AI news
Hash indexes
Dec. 15, 2023, 2 p.m. | Nikolay Samokhvalov and Michael Christofides
Postgres FM postgres.fm
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) …
More from postgres.fm / Postgres FM
Jobs in AI, ML, Big Data
Data Engineer
@ Michelin | Pune
Senior Research Analyst, Global Analytics & Measurement
@ NBCUniversal | London, United Kingdom
Research Scientist
@ Meta | Menlo Park, CA
NLP Speech Research Intern
@ Tencent | UK-London
Junior Senior Reliability Engineer
@ NielsenIQ | Bogotá, Colombia
[Job - 15712] Vaga Afirmativa para Mulheres - QA (Automation), SR
@ CI&T | Brazil