PostgreSQL 18's new `num_os_semaphores` preset reports how many OS semaphores the server needs—a formula that drifted wrong for twelve years until...
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.
We've helped...
PGX on Social Media
ClickHouse measured a buffered base backup of a 467 GB Postgres under load: it evicted a warm, idle 40 GiB table from the page cache in about 20 seconds, and query p99 stayed 3x baseline for 2.5 minutes after the backup ended. clickhouse.com/blog/direct-... pgexperts.com #PostgreSQL #DevOps
— PGX (@pgexperts.bsky.social) 2026-10-07T17:07:01.510Z

