Extended Statistics | Postgres.FM 135 |
Автор: PostgresTV
Загружено: 2025-02-28
Просмотров: 287
Описание:
[ 🇬🇧_🇺🇸 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 the CREATE STATISTICS feature in Postgres — what it's for, how often it's used, and how to spot cases where it would help.
Here are some links to things they mentioned:
CREATE STATISTICS https://www.postgresql.org/docs/curre...
citext https://www.postgresql.org/docs/curre...
Statistics Used by the Planner https://www.postgresql.org/docs/curre...
default_statistics_target https://www.postgresql.org/docs/curre...
Tomáš Vondra on Postgres TV • s01e06 Tomáš Vondra
Recent commit to Postgres 18 for pg_upgrade https://git.postgresql.org/gitweb/?p=...
Multivariate Statistics Examples https://www.postgresql.org/docs/curre...
Extended statistics (README) https://github.com/postgres/postgres/...
How we used Postgres extended statistics to achieve a 3000x speedup (blog post by Jared Rulison) https://build.affinity.co/how-we-used...
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @postgresfm / postgresfm , @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is produced by:
Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/
Michael Christofides, founder of pgMustard https://pgmustard.com/
~~~
This is the video version. Check out https://postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: