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...