How to Minimize Downtime Caused by Table Locks During PostgreSQL Schema Changes?

🚨 Ever faced an unexpected downtime from a seemingly harmless database deployment?Imagine you're adding a new column to an existing table (e.g., users) in PostgreSQL. You decided to skip specifying a default value, thinking it would be a metadata-on...