Presented by:

2bf10c28c20edcdd79792f1c2835af08

Shane Borden

Google

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