[ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try KZitem'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) www.pgmustard....
Why isn’t Postgres using my functional index? (Stack Exchange question from Brent Ozar) dba.stackexcha...
enable_seqscan (and similar parameters) www.postgresql...
Crunchy Bridge changed random_page_cost to 1.1 docs.crunchybr...
Make indexes invisible (trick from Haki Benita) hakibenita.com...
ANALYZE www.postgresql...
Statistics used by the planner www.postgresql...
Our episode on query hints postgres.fm/ep...
transaction_timeout (commit for Postgres 17) git.postgresql...
What’s new in the Postgres 16 query planner / optimizer (blog post by David Rowley) www.citusdata....
~~~
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 postgres.ai/
Michael Christofides, founder of pgMustard pgmustard.com/
~~~
This is the uncut version, with video. Check out Postgres.fm to find audio-only podcast episodes, edited for convenient listening.
Негізгі бет Why isn't Postgres using my index? | Postgres.FM 085 |
Пікірлер: 13