Postgres

• Always Load Sorted Data
• Anomaly Detection With Stats
• Avoid Indexes on Columns With Low Selectivity
• Brin Index
• Btree Index
• Cluster
• Coalesce
• Disable Constraints and Indexes During Bulk Loads
• Explain and Analyze
• Formatting Timestamps
• Gin Index
• Hash Index
• Locking Select
• Make Indexes Invisible
• Partial Indexes
• Row Level Security
• Schedule at Uneven Times
• Type Casting
• Unlogged Tables
• Update Only What Needs Updating
• Use Hashing to Reduce Disk Usage
• Vacuum