Рет қаралды 648
[ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try KZbin'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) www.postgresql.org/docs/curre...
* Statistics used by the planner (docs) www.postgresql.org/docs/curre...
* default_statistics_target www.postgresql.org/docs/curre...
* Optimiser hints discussion (wiki) wiki.postgresql.org/wiki/Opti...
* An example mailing list thread from 2006 www.postgresql.org/message-id...
* Peter Geoghegan tweet regarding invalid index / 1599191964045672449
* plantuner sigaev.ru/git/gitweb.cgi?p=pla...
* pg_hint_plan github.com/ossc-db/pg_hint_plan
* Aurora PostgreSQL query plan management 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 adv...
* hypopg 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 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.