Indexing JSONB in PostgreSQL: GIN Operator Class Guide
Choose the right GIN operator class for JSONB indexes in Postgres—jsonb_path_ops vs jsonb_ops, expression indexes, and real EXPLAIN benchmarks.
Field guide / topic hub
Indexing Strategies
How PostgreSQL indexes work and how to choose access paths for relational, JSONB, array, and spatial data.
Operational notes
3 publishedPostgres Indexing Basics: What EXPLAIN Actually Shows
Learn how Postgres picks indexes, when it skips them, and how to read EXPLAIN ANALYZE buffers instead of guessing at query speed.
Postgres Index Types: B-Tree vs GIN vs GiST vs BRIN
Postgres index types explained: when to use B-tree, GIN, GiST, or BRIN, with real EXPLAIN output and a decision table for indexing strategy.