Postgres

Constraints

• SET CONSTRAINTS
• SET NOT NULL

Indexing

• Indexing for LIKE
• Concurrent index during vacuum
• Postgres BRIN index
• No Automatic Index on FKs
• DROP INDEX CONCURRENTLY

Planning

• A PSQL Planner Primer

Locks

• lock_timeout
• Locks cheatsheet