5mins of Postgres E39: Postgres 15 release, and 6 tips for managing indexes

Опубликовано: 29 Сентябрь 2024
на канале: pganalyze
443
25

We talk about the Postgres 15 release, and six findings to improve how you manage your Postgres indexes.

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  

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:

Tom Lane’s commit about the release date of Postgres 15
https://git.postgresql.org/gitweb/?p=...

postgresql.org
https://www.postgresql.org/

Six findings we rely on when managing PostgreSQL indexes - by Billy Ceskavich
https://knock.app/blog/postgres-index...

Billy Ceskavich on Twitter
  / ceskavich  

5mins of Postgres E38: When to use BRIN indexes in Postgres, tuning pages_per_range and determining correlation with pg_stats
https://pganalyze.com/blog/5mins-post...

pganalyze Index Advisor for Postgres
https://pganalyze.com/postgres-index-...

How we deconstructed the Postgres planner to find indexing opportunities
https://pganalyze.com/blog/deconstruc...

Effective Indexing in Postgres - pganalyze eBook
https://pganalyze.com/ebooks/postgres...

How To Reason About Indexing Your Postgres Database - pganalyze webinar
https://pganalyze.com/webinars/how-to...

5mins of Postgres E17: Demystifying Postgres for application developers: A mental model for tables and indexes
https://pganalyze.com/blog/5mins-post...