5mins of Postgres E1: Using Postgres statistics to improve bad query plans, pg_hint_plan extension
Today we'll talk about bad query plans, how to use Postgres statistics to improve them, and if that doesn't work, what options exist to hint a particular query plan so that Postgres uses a different plan that it would usually use.
Find the article on our blog here: https://pganalyze.com/blog/5mins-post...
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
What we have discussed in this episode of 5mins of Postgres:
https://spacelift.io/blog/tricking-po...
https://aws.amazon.com/rds/aurora/ser...
https://news.ycombinator.com/item?id=...
https://build.affinity.co/how-we-used...
https://github.com/ossc-db/pg_hint_plan