Handling outliers in BRIN indexes with the new multi minmax operator class

*Find the article on our blog here:* https://pganalyze.com/blog/5mins-postgres-brin-index-outliers-minmax-multi-ops

In E79 of “5mins of Postgres” we're going to talk about when good correlation is not enough, the cases where BRIN indexes can be worse than having no index at all.

*Learn more about pganalyze:*

https://pganalyze.com

https://pganalyze.com/newsletter

https://twitter.com/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:*

*When Good Correlation is Not Enough - by Haki Benita*

https://hakibenita.com/postgresql-correlation-brin-multi-minmax

*Haki Benita on Twitter*

https://twitter.com/be_haki

*First-draft release notes for 15.4. - postgresql.org*

https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=doc/src/sgml/release-15.sgml;h=e93fa630f5814019da0372f2a9658717f1e7512c;hb=c6344d7686f3e3c8243c2c6771996cfc63e71eae

*Learn more about indexing in Postgres*

*pganalyze Webinar recording: How to reason about indexing your Postgres database*

https://www.youtube.com/watch?v=o0HrXM1thYI

*Effective Indexing in Postgres - pganalyze eBook*

https://pganalyze.com/ebooks/postgres-indexing

*5mins of Postgres E17: Demystifying Postgres for application developers: A mental model for tables and indexes*

https://pganalyze.com/blog/5mins-postgres-for-app-developers-tables-indexes

*The Unexpected Find That Freed 20GB of Unused Index Space*

https://pganalyze.com/blog/partial-indexes-freed-20gb-index-space

*How Postgres Chooses Which Index To Use For A Query*

https://pganalyze.com/blog/how-postgres-chooses-index

*5mins of Postgres E6: Optimizing Postgres Text Search with Trigrams and GiST indexes*

https://pganalyze.com/blog/5mins-postgres-optimizing-postgres-text-search-trigrams-gist-indexes

*Understanding Postgres GIN Indexes: The Good and the Bad*

https://pganalyze.com/blog/gin-index

*Using Postgres CREATE INDEX: Understanding operator classes, index types & more*

https://pganalyze.com/blog/postgres-create-index

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

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

*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-postgres-BRIN-index