1
Is Postgres read heavy or write heavy?
A query to find out if Postgres is read heavy or write heavy and tips for optimizing Postgres for both read and write workloads.
Crunchy Data Blog
Deploy enterprise-ready PostgreSQL on your choice of platform and infrastructure with commercial support from Crunchy Data.
- Popular posts
- 15
- Total points
- 3,277
- HN comments
- 891
- Rank
- #352 company
Visit crunchydata.com → On Hacker News May 2022 – Jun 2026
Databases & Data 15Software Engineering 5Systems & Performance 4Web & Frontend 2Infrastructure & DevOps 2Tech Industry & Business 1
2
Postgres Data Flow
What happens when you query Postgres? Data can actually come from many different places like the application cache, buffer cache, and even down into the physical disk cache. This post surveys the data storage and flow of Postgres data.
3
Demystifying Database Performance for Developers
For developers, databases are basically magic. Like Penn & Teller, this blog post is set to break the illusion. Databases are just like any other code, they have algorithms and processes. These algorithms and processes are meant to improve performance, but can cause limitations if they are not expected.
4
Postgres WAL Files and Sequence Numbers
Go inside the WAL file with this in-depth look at WAL file Log Sequence Number (LSN), WAL segment positions, WAL file names, and pg_switch_wal.