postgres12 min read
PostgreSQL JSONB Patterns — Flexible Schema Without Sacrificing Performance
Master JSONB storage, GIN indexing (jsonb_ops vs jsonb_path_ops), query patterns, validation constraints, and migration from NoSQL databases.
Read →
Indexing
2 articles
postgresql6 min read
PostgreSQL Indexing Strategies — B-Tree, GIN, BRIN, and Partial Indexes in Production
Master PostgreSQL indexing strategies including B-Tree for general queries, GIN for JSONB/arrays, BRIN for time-series, partial indexes, covering indexes, and how to identify unused indexes with pg_stat_user_indexes.
Read →