Why isn't Postgres using my index? | Postgres.FM 085 |
[ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
Nikolay and Michael discuss a common question — why Postgres isn't using an index when you think it should be!
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-is...
* Why isn’t Postgres using my functional index? (Stack Exchange question from Brent Ozar) https://dba.stackexchange.com/questio...
* enable_seqscan (and similar parameters) https://www.postgresql.org/docs/curre...
* Crunchy Bridge changed random_page_cost to 1.1 https://docs.crunchybridge.com/change...
* Make indexes invisible (trick from Haki Benita) https://hakibenita.com/sql-tricks-app...
* ANALYZE https://www.postgresql.org/docs/curre...
* Statistics used by the planner https://www.postgresql.org/docs/curre...
* Our episode on query hints https://postgres.fm/episodes/query-hints
* transaction_timeout (commit for Postgres 17) https://git.postgresql.org/gitweb/?p=...
* What’s new in the Postgres 16 query planner / optimizer (blog post by David Rowley) https://www.citusdata.com/blog/2024/0...
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/
- Michael Christofides, founder of pgMustard https://pgmustard.com/
~~~
This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.