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