Over indexing | Postgres.FM 068 |
[ 🇬🇧_🇺🇸 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 over-indexing — what we mean by it, the regular issues people discuss about it, as well as a novel one Nikolay has come across and benchmarked recently.
Here are some links to things they mentioned:
Query planning (docs) https://www.postgresql.org/docs/curre...
Statistics used by the planner (docs) https://www.postgresql.org/docs/curre...
default_statistics_target https://www.postgresql.org/docs/curre...
Optimiser hints discussion (wiki) https://wiki.postgresql.org/wiki/Opti...
An example mailing list thread from 2006 https://www.postgresql.org/message-id...
Peter Geoghegan tweet regarding invalid index / 1599191964045672449
plantuner http://sigaev.ru/git/gitweb.cgi?p=pla...
pg_hint_plan https://github.com/ossc-db/pg_hint_plan
Aurora PostgreSQL query plan management https://docs.aws.amazon.com/AmazonRDS...
Building automatic adviser & performance tuning tools - Julien Rouhaud & Tatsuro Yamada: PGCon 2020 (the completely misremembered presentation Michael mentioned 🙈) • Building automatic adviser & performa...
hypopg https://github.com/HypoPG/hypopg
~~~
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.