Скачать или смотреть How to use CREATE STATISTICS to improve a plan rows estimate, and why it matters

Find the article on our blog here:
https://pganalyze.com/blog/5mins-post...

In E92 of “5mins of Postgres”, we're going to talk about creating functional dependency statistics to improve plan cost estimates in Postgres. We’re looking at a problem that I myself encountered last week when I was trying to optimize the estimates we're getting for a particular query inside our own system.

Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
  / pganalyze  

Check out the pganalyze library for eBooks, webinars, and more:
https://pganalyze.com/resources

📑 What we have discussed in this episode of 5mins of Postgres:

Statistics Used by the Planner - postgresql.org
https://www.postgresql.org/docs/curre...


CREATE STATISTICS - postgresql.org
https://www.postgresql.org/docs/curre...

ALTER STATISTICS - postgresql.org
https://www.postgresql.org/docs/curre...

clausesel.c file - Postgres core
https://github.com/postgres/postgres/...

extended_stats.c file - Postgres core
https://github.com/postgres/postgres/...

dependencies.c file - Postgres core
https://github.com/postgres/postgres/...