5mins of Postgres E48: Benchmarking multi column, covering and hash indexes in Postgres
Today, we talk about benchmarking multi-column vs. multiple combined indexes in Postgres, and whether B-Tree or hash indexes are a better fit. We also look into cases and workloads where different indexes are better than other ones.
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:
The bountiful world of Postgres indexing options - by Kaarel Moppel
https://kmoppel.github.io/2022-12-09-...
Kaarel Moppel on GitHub
https://github.com/kmoppel
Index Merges vs Composite Indexes in Postgres and MySQL - by Simon Hørup Eskildsen
https://sirupsen.com/index-merges
Simon Hørup Eskildsen on Twitter
/ sirupsen
UNLOGGED tables - postgreSQL.org documentation
https://www.postgresql.org/docs/curre...
WAL logging - postgreSQL.org
https://www.postgresql.org/docs/curre...
pgbench
https://www.postgresql.org/docs/curre...
Lessons Learned from Running Postgres 13: Better Performance, Monitoring & More - Smaller Indexes with B-Tree Deduplication
https://pganalyze.com/blog/postgres13...
Learn more about Indexing in Postgres
pganalyze Webinar recording: How to reason about indexing your Postgres database
• Webinar recording: How to reason abou...
Effective Indexing in Postgres - pganalyze eBook
https://pganalyze.com/ebooks/postgres...
5mins of Postgres E17: Demystifying Postgres for application developers: A mental model for tables and indexes
https://pganalyze.com/blog/5mins-post...
The Unexpected Find That Freed 20GB of Unused Index Space
https://pganalyze.com/blog/partial-in...
How Postgres Chooses Which Index To Use For A Query
https://pganalyze.com/blog/how-postgr...
5mins of Postgres E6: Optimizing Postgres Text Search with Trigrams and GiST indexes
https://pganalyze.com/blog/5mins-post...
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-c...
5mins of Postgres E39: Postgres 15 release, and 6 tips for managing indexes
https://pganalyze.com/blog/5mins-post...
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...