JSONB

Posts tagged “JSONB”.

JSONBClear filters
PostgreSQL Expression Indexes Explained (With Examples)

PostgreSQL Expression Indexes Explained (With Examples)

A practical guide to the PostgreSQL expression index: syntax, the IMMUTABLE requirement, exact planner matching, JSONB and date_trunc examples, and the write-amplification trade-off.

August 31, 2026 · 9 min read

Mobin Yazdanparast
PostgreSQL GIN Index: Complete Guide

PostgreSQL GIN Index: Complete Guide

Learn how the PostgreSQL GIN index optimizes JSONB, arrays, and full-text search. Master creation, tuning, and comparisons to speed up queries.

August 17, 2026 · 8 min read

Mobin Yazdanparast