log_lock_waits is the cheapest lock-contention detector PostgreSQL ships, and through version 18 it is off by default. Turn it on. PostgreSQL 19...
PostgreSQL Experts,
because your data is your
business.
PGX is a specialist PostgreSQL consultancy. Founded in 2009, we are deep PostgreSQL experts, with decades of experience in everything from data corruption repair and emergency service through database tuning and troubleshooting, to strategic data planning.
We offer a variety of support and consulting plans, tailored to the needs of organizations of any size, from small startups through Fortune 5 enterprises.
Recent Talks
Language is a Virus: Locales and PostgreSQL
Christophe Pettus, March 6, 2025
Southern California Linux Expo 2025
Latest Commit
4 September 2026 15:56 UTC
Convert some ParallelBlockTableScanDescData fields to atomics.
Currently, phs_startblock and phs_numblock are of type BlockNumber and are protected by a spinlock. By converting them to atomic variables, we can remove the spinlock and some retry code.
- Reviewed-by: Zsolt Parragi zsolt.parragi@percona.com
- Tested-by: solai v solai.cdac@gmail.com
- Discussion
PostgreSQL News
4 September 2026 01:00 UTC
Christophe Pettus: All Your GUCs in a Row: log_lock_waits and log_lock_failures
3 September 2026 16:13 UTC
Umair Shahid: Database Availability Is a Stack: Rolling OS Patching
Key takeawaysA routine OS patch can take Postgres offline even when Postgres itself was never touched. Here’s what rolling OS patching on a proper...
3 September 2026 14:50 UTC
Devrim GÜNDÜZ: PostgreSQL RPM repo comes to Amazon Linux 2023!
If you run PostgreSQL on EC2, you've had two real choices until now: build from source, or fall back to whatever version Amazon Linux itself...
news feed via Planet PostgreSQL.
