#
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
Postgres 19: How Our Advice Has Changed Since We Wrote It
·
Crunchy Data
·
Aug. 18, 2026, 7:16 p.m.
Production Postgres
Postgres 19
postgresql
Performance Optimization
Database Management
Data Storage Techniques
Summary
This blog post revisits previous advice on Postgres features such as COPY, TOAST, BRIN, indexes, and partitioning, evaluating how recommendations have evolved across Postgres versions, ultimately focusing on updated recommendations for Postgres 19.
Read full post on www.crunchydata.com →
MORE POSTS LIKE THIS
What REPACK (CONCURRENTLY) costs while it runs
Radim Marek ·
Sep 27, 2026
concurrency
software development
Autovacuum: The Tax You're Always Paying
Timescale ·
May 5, 2026
postgresql
PostgreSQL Performance
PostGIS Performance: Data Sampling
Crunchy Data ·
Nov 21, 2025
PostGIS Performance
Postgis
What is Fill Factor in PostgreSQL
özkan pakdil ·
Feb 18, 2025
SQL
postgresql
Managed Postgres: What Lakebase Actually Takes Off Your Plate
Mooncake ·
Sep 15, 2026
Data + AI Foundations
postgresql
Hiring and firing a DBA
Applied Cartography ·
Sep 7, 2026
hiring
Performance Optimization
Discover more posts →
AUTHOR
Advertise
Sponsor diff.blog
Put your product in front of developers who read and write about their craft. One exclusive sponsor at a time.
Become a sponsor →
BLOG POST FEATURED ON
Hacker News
5 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
.