Postgres

Constraints

• SET CONSTRAINTS
• SET NOT NULL
• EXCLUDE USING

Outages

• FKs Without Downtime
• Long Transactions
• DEFAULT
• Drop Column With Index
• CHECK Constraints Without Downtime
• Is This DDL Going To Rewrite The Table?
• Renaming A Table Using VIEW

Indexing

• Indexing for LIKE
• Concurrent index during vacuum
• Postgres BRIN index
• No Automatic Index on FKs
• DROP INDEX CONCURRENTLY
• Composed index vs denormalised column index
• REINDEX CONCURRENTLY

Planning

• A PSQL Planner Primer

Locks

• lock_timeout
• Locks cheatsheet
• Print lock for query
• Deadlock Demonstration
• Advisory Lock

Testing

• Postgres Docker Container

Performance

• OR queries
• JSON filtering vs text casting
• Table bloat

Internals

• Building From Source
• Profiling Postgres On Linux
• Profiling Postgres On Mac
• Debugging Postgres

Extensions

• pg_repack
• pgcrypto

Transactions

• Transaction Isolation

PSQL

• A Basic psql Workflow