Why isn’t Postgres using my index? | Postgres.FM 085 | #PostgreSQL #Postgres podcast

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)
* Why isn’t Postgres using my functional index? (Stack Exchange question from Brent Ozar)
* enable_seqscan (and similar parameters)
* Crunchy Bridge changed random_page_cost to 1.1
* Make indexes invisible (trick from Haki Benita)
* ANALYZE
* Statistics used by the planner
* Our episode on query hints
* transaction_timeout (commit for Postgres 17)
* What’s new in the Postgres 16 query planner / optimizer (blog post by David Rowley)

~~~

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 and @michristofides

~~~

Postgres FM is brought to you by:
– Nikolay Samokhvalov, founder of Postgres.ai
– Michael Christofides, founder of pgMustard

~~~

This is the uncut version, with video. Check out to find audio-only podcast episodes, edited for convenient listening.

[ad_2]

source