Category: Performance and tuning

Posts on configuration tuning (memory, WAL, autovacuum), indexing strategies, and query optimization.

Before/after case studies showing how specific changes affected latency, throughput, or cost.

Performance and tuning postgresql

PostgreSQL 18 Async I/O on AWS: Why 2–3× Throughput Doesn’t Mean 3× Smaller Instances

The PostgreSQL 18 async I/O feature has generated a lot of excitement—and for good reason. Lab benchmarks show 2–3× better read throughput on cloud storage compared to synchronous I/O. But if you’re expecting to downsize your AWS RDS instances by 3× and pocket massive savings, I have news: real-world deployments tell a more nuanced story. […]

Avatar photo admin