#
DIFF.BLOG
New
Following
Discover
Jobs
More
Top Writers
Suggest a blog
Upvotes plugin
Report bug
Contact
About
Privacy
Sign up
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
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
.