Postgres and Open Source Experts

Anytime. Anywhere. Since 1997.

Blog

When huge_pages Help: Using PSI to Find Bottlenecks Before You Decide

When huge_pages Help: Using PSI to Find Bottlenecks Before You Decide

Benchmarking huge_pages on a 128 GB PostgreSQL 18 system shows throughput gains are modest — but page table overhead at 4KB pages can consume up to 20% of total RAM. Use PSI to find where your system is actually stalling before making the call. Part 2 of 3.

Beyond the 25% Rule: shared_buffers Behavior in Large-Memory PostgreSQL

Beyond the 25% Rule: shared_buffers Behavior in Large-Memory PostgreSQL

Tuning shared_buffers isn't just about peak throughput — it's about how much CPU and disk I/O a system consumes per unit of work. The 25% default can require up to 5x more disk I/O than very low or very high allocation. Part 1 of 3.

Service Monitoring via Hazard Analysis White Paper

Service Monitoring via Hazard Analysis White Paper

A modern approach to IT observability inspired by hazard analysis. Learn how to improve system reliability, reduce monitoring complexity, and proactively manage service risks through Critical Control Points.

Less is More

Sometimes, after using a tool for many years, you will discover a feature that totally changes how you do things. When it is a fundamental tool like “less”, it changes how you interact with many command line programs in Linux*.

Did you know that less can do far more than just press space to advance to the next page? I sure didn’t. Then one day I went down the rabbit …