Indexing Postgres: Creating The Best Index For Your Queries
Learn how to create the best Postgres index for your queries. A deep dive into index types, operators, data types and more.
Indexing can make a significant impact on the performance of your application’s query workload. Too many indexes will slow down your write performance, but creating the right indexes can often improve your query performance by 10x or even 100x.
In this book, you will learn:
- How Postgres uses indexes
- Data types, operators and index types
- B-tree indexes, Hash indexes, BRIN indexes, and Generic Index Types (GIN, GIST, SP-GIST)
- How to create the best indexes for your queries
Download this eBook
Hundreds Of Companies Monitor Their Production PostgreSQL Databases With pganalyze
