---
title: "Discussion on \"How to Minimize Downtime Caused by Table Locks During PostgreSQL Schema Changes?\" | Hashnode"
description: "Discussion on \"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..."
url: "https://hashnode.com/posts/how-to-minimize-downtime-caused-by-table-locks-during-postgresql-schema-changes/677a3501bffcd860f246aea5"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [How to Minimize Downtime Caused by Table Locks During PostgreSQL Schema Changes?](https://dbaguides.hashnode.dev/how-to-minimize-downtime-caused-by-table-locks-during-postgresql-schema-changes?utm_source=hashnode&utm_medium=feed)

🚨 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...

Jan 5, 2025 · 2 min read · dbaguides.hashnode.dev  
Read the article

-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#dbaguides](https://hashnode.com/tag/dbaguides)
-   [#databases](https://hashnode.com/tag/databases)
-   [#deployment](https://hashnode.com/tag/deployment)

## Written by

[Arindam Ghosh](https://hashnode.com/@arinpro)

@arinpro

  
[View profile](https://hashnode.com/@arinpro)

Database Enthusiast 📊 | Database Reliability Engineer 👨‍💻 | Database DevOps 🚀

Database reliability engineer 👨‍💻 with expertise in designing, implementing, and maintaining highly available and scalable database systems 💻 Enjoy automating various database tasks ⚙️ and implementing database DevOps 🚀 🙏

## Responses

Markdown supported · ⌘↵ to post

No responses yet.