PostgreSQL JSONB Indexing: GIN, Expression & Partial Index Strategies
PostgreSQL JSONB Indexing: GIN, Expression & Partial Index Strategies
Last week I reviewed an application where a 5-million-row events table with a JSONB metadata column had a GIN index, a 250ms query SLA, and sequential scans on every single JSONB q...
postgresdba.hashnode.dev4 min read