all AI news
Why isn't Postgres using my index?
Feb. 23, 2024, 2 p.m. | Nikolay Samokhvalov and Michael Christofides
Postgres FM postgres.fm
Nikolay and Michael discuss a common question — why Postgres isn't using an index, and what you can do about it!
Here are some links to things they mentioned:
- Why isn’t Postgres using my index? (blog post by Michael) https://www.pgmustard.com/blog/why-isnt-postgres-using-my-index
- Why isn’t Postgres using my functional index? (Stack Exchange question from Brent Ozar) https://dba.stackexchange.com/questions/336019/why-isnt-postgres-using-my-functional-index
- enable_seqscan (and similar parameters) https://www.postgresql.org/docs/current/runtime-config-query.html
- Crunchy Bridge changed random_page_cost to 1.1 https://docs.crunchybridge.com/changelog#postgres_random_page_cost_1_1
- Make indexes invisible (trick from Haki Benita) https://hakibenita.com/sql-tricks-application-dba#make-indexes-invisible
- ANALYZE https://www.postgresql.org/docs/current/sql-analyze.html
- Statistics used by the …
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