Find the article on our blog here:
pganalyze.com/...
In E115 of "5mins of Postgres" we discuss a common challenge when using equality and contains operators for querying JSONB columns, and why the Postgres planner will often get the estimates wrong for such queries, causing bad query plans.
Learn more about pganalyze:
pganalyze.com
pganalyze.com/...
/ pganalyze
Check out the pganalyze library for eBooks, webinars, and more:
pganalyze.com/...
📑 What we have discussed in this episode of 5mins of Postgres:
PostgreSQL Stories: From slow query to fast-via stats - Blog post by Eric Fritz on the Render blog
render.com/blo...
Pitfalls of JSONB indexes in PostgreSQL - Blog post by Vsevolod Solovyov
vsevolod.net/p...
PostgreSQL: JSONB and Statistics - Blog post by Adrien Nayrat
blog.anayrat.i...
Less-silly selectivity for JSONB matching operators - Mailinglist thread on pgsql-hackers by Tom Lane
www.postgresql...
Improve selectivity estimation for assorted match-style operators - Postgres 13 commit by Tom Lane
git.postgresql...
Extended statistics on expressions - Postgres 14 commit by Tomas Vondra
git.postgresql...
Негізгі бет Postgres Planner Quirks: How to fix bad JSONB selectivity estimates
Пікірлер: 1