Skip to content

title: Postgres indexing & partitioning description: When and how to add indexes: B-tree, partial, GIN, and covering indexes. status: stub tags: - data - postgres

Postgres indexing & partitioning

Stub page

Common indexes you should have, and partitioning starting points.

Planned content

  • Composite indexes: column order rules
  • Partial indexes
  • GIN indexes for jsonb / array / full-text
  • Range partitioning by time + pg_partman