Schedule - PGConf NYC 2024

Indexing Beyond Columns: Expressions, Text Fragments, JSON Attributes, and Top-N Queries

Date: 2024-10-01
Time: 10:40–11:30
Room: Club Parlor
Level: Beginner
Feedback: Leave feedback

Are you indexing your table's columns? It's time to explore a different approach. Instead of simply indexing columns, consider indexing the specific values and ranges you will search for. While in a highly normalized schema, this typically translates to one or more columns, modern applications often require searching for criteria within a text fragment, an attribute within a JSON structure, or the maximum values across multiple rows. In this session, we will explore several examples and evaluate the effectiveness of indexing by examining the execution plan.

Slides

The following slides have been made available for this session:

Speaker

Franck Pachot