#
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
Getting rid of a 4 TB table in PostgreSQL
Radim Marek ·
Oct 31, 2026
data engineering
postgresql
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
Navicat 18 Review: Is It Worth It for PostgreSQL? Tested on 10M Rows
Aleksei Aleinikov ·
Nov 2, 2026
navicat
navicat-review
Enums Can Be Enforced at the Database Level in PostgreSQL
Nelson Figueroa ·
Oct 29, 2026
software development
postgresql
Discover more posts →
AUTHOR
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
.