Postgres

• 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.
• Use uppercase for SQL key words and lowercase for SQL identifiers.