DIFF.BLOG
New Following Discover Jobs
More
Top Writers Suggest a blog Upvotes plugin
Report bug Contact About Privacy
Sign up
Topics
Follow your own topics →
Menu
New Following Discover Jobs Top Writers
More
Suggest a blog Upvotes plugin Report bug Contact About
Sign up
Privacy Policy
The home for great developer writing.
We surface the best developer writing from thousands of independent blogs, updated daily.
Join Diff.blog
TOPICS

When Does ALTER TABLE Require a Rewrite?

· Crunchy Data · Jan. 27, 2025, 5:32 p.m.
Production Postgres Postgres postgresql Performance Optimization Database Management
Summary
The blog post discusses an approach to determine when an ALTER TABLE command requires a full rewrite in Postgres, highlighting the author's unique insights into PostgreSQL internals.
Read full post on www.crunchydata.com →
MORE POSTS LIKE THIS
Getting rid of a 4 TB table in PostgreSQL
Radim Marek · Oct 31, 2026
data engineering postgresql
Autoscaling Lakebase Postgres
Mooncake · Aug 31, 2026
engineering data engineering
Postgres 19: How Our Advice Has Changed Since We Wrote It
Crunchy Data · Aug 18, 2026
Production Postgres Postgres 19
The Postgres Developer's Guide to Vector Index Tradeoffs
Timescale · May 26, 2026
pg_textsearch postgresql
What is Fill Factor in PostgreSQL
özkan pakdil · Feb 18, 2025
SQL postgresql
Navicat 18 Review: Is It Worth It for PostgreSQL? Tested on 10M Rows
Aleksei Aleinikov · Nov 2, 2026
navicat navicat-review
Discover more posts →
AUTHOR
BLOG POST FEATURED ON

Placeholder image
r/PostgreSQL

6 points

Add this plugin to your blog
RECENT POSTS FROM THE AUTHOR
Choose how you want to continue.
Continue with GitHub Continue with Google
By continuing, you agree to our Privacy Policy.