GIN

0001-01-01

An Indexing Strategy

Indexes follow from your queries, not your tables. An index is a named trade: faster reads in exchange for slower writes. Only make trades you can justify.

0001-01-01

JSONB and Arrays

PostgreSQL’s JSONB and array types let you store semi-structured data without leaving the relational model — and without sacrificing indexability or query power.