Unlocking PostgreSQL Performance: A Guide to Index Types and When They Should Be Used
Presented by:

Shane Borden
Experienced technology professional with a successful career in leading or managing highly visible, complex data architecture design and production support tasks across multiple reference architectures.
Recently have been focused on making the cloud journey for clients easier especially the journey from Oracle / SQL Server to all things PostgreSQL.
Generally I am focused on the following cloud and database technologies:
Cloud SQL for PostgreSQL
AlloyDB for PostgreSQL
PostgreSQL
Cloud Replication Products (Oracle Goldengate, Striim, HVR and FiveTran)
Oracle Database (All Versions)
Oracle Engineered Systems
Data Virtualization and Big Data Platforms
Marginally dangerous with Microsoft SQL Server
Also a life long aviation enthusiast.
No video of the event yet, sorry!
In the world of relational databases, indexes are crucial for optimizing query performance. PostgreSQL, a powerful open-source database system, offers a variety of index types beyond the standard B-tree. This presentation delves into the different index types available in PostgreSQL, exploring their strengths, weaknesses, and ideal use cases.
Specifically, we will cover and show use cases for the following types of indexes: We will cover and demonstrate use cases for:
- B-tree Indexes
- Hash Indexes
- GIN /GiST Indexes
- BRIN Indexes
- BLOOM
- Vector Indexes
- Date:
- 2025 March 21 11:30 EDT
- Duration:
- 50 min
- Room:
- Space Coast 1&2
- Conference:
- Postgres Conference 2025
- Language:
- Track:
- Ops
- Difficulty:
- Easy