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 / tag
Indexing Strategies
Every public pgdba.dev field note carrying this operational signal.
Tagged 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.