Postgres

Constraints

• SET CONSTRAINTS
• SET NOT NULL
• EXCLUDE USING

Outages

• FKs Without Downtime
• Long Transactions
• DEFAULT
• Drop Column With Index
• CHECK Constraints Without Downtime
• UNIQUE 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
• Slow ORDER BY and LIMIT

Internals

• Building From Source
• Profiling Postgres On Linux
• Profiling Postgres On Mac
• Debugging Postgres
• How Postgres Implements Foreign Keys
• Swapping a Table With its Copy

Disk

• How table data is stored in disk

Extensions

• pg_repack
• pgcrypto
• how extensions are created

Third Party Packages

• pgroll

Transactions

• Transaction Isolation

PSQL

• A Basic psql Workflow

Vacuum

• VACUUM Phases
• Replication slots blocking VACUUM

Documentation

• Postgres Documentation Syntax

Fields

• Choosing between varchar and varchar(n)