5mins of Postgres E24: Tuning Postgres statistics target, understand selectivity for spatial indexes
Today, we are talking about Postgres indexes, selectivity - specifically for spatial indexes - and using Postgres statistics.
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:
Postgres Indexes, Selectivity, and Statistic: https://www.crunchydata.com/blog/inde...
Paul Ramsey on Twitter: / pwramsey
Postgres source code - analyze.c: https://github.com/postgres/postgres/...
Pareto principle - Wikipedia: https://en.wikipedia.org/wiki/Pareto_...
PostGIS: https://postgis.net/
Amazon Aurora now supports PostgreSQL 14: https://aws.amazon.com/about-aws/what...
AWS Docs: PostgreSQL 14.3 on Amazon Aurora: https://docs.aws.amazon.com/AmazonRDS...
5mins of Postgres E1: Using Postgres statistics to improve bad query plans, pg_hint_plan extension: https://pganalyze.com/blog/5mins-post...
5mins of Postgres E15: Tuning Postgres' Deterministic Query Planner, Extended Statistics and Join Collapse Limits: https://pganalyze.com/blog/5mins-post...
5mins of Postgres E20: An important bug in Postgres 14 with REINDEX / CREATE INDEX CONCURRENTLY, and using the amcheck extension: https://pganalyze.com/blog/5mins-post...