- Avoid multicolumn indexes. Postgres combines multiple indexes efficiently. Optimize later with a compound index if needed.
- Consider a partial index for queries on booleans.
- Avoid JSONB columns unless you have a strong reason to store an entire JSON document from an external source.