A recent question on the community channels described a difficult situation: a standby had been promoted with archive_mode=off, and restarting the...
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.
We've helped...
PGX on Social Media
One week from today, Stacey Haysler will be giving her new talk “From Inclusion to Involvement” at Postgres Summit US 2026! Join the discussion and learn new ways to participate in the community! postgresql.us/events/postg... #PostgreSQL #Inclusion #Involvement
— PGX (@pgexperts.bsky.social) 2026-09-23T14:33:01.317Z
Recent Talks
Language is a Virus: Locales and PostgreSQL
Christophe Pettus, March 6, 2025
Southern California Linux Expo 2025
Latest Commit
23 September 2026 13:18 UTC
Fix incorrect block accounting in TID Range Scans
heapgettup_advance_block() (or heapgettup() and heapgettup_pagemode() in versions before v16) would incorrectly decrement rs_numblocks when advancing to the next block. Ordinarily this was fine, but if the TID Range scan plan was used by a scrollable cursor and the cursor was fetched backwards enough to result in another block being required, then rs_numblocks may have reached 0 prematurely resulting in the scan ending prematurely.
- Reported-by: Jeff Davis pgsql@j-davis.com
- Author: Ewan Young kdbase.hack@gmail.com
- Author: David Rowley dgrowleyml@gmail.com
- Discussion
- Backpatch-through: 14
PostgreSQL News
23 September 2026 13:35 UTC
Stefan Fercot: pgBackRest and PostgreSQL failover: why archive_mode matters
23 September 2026 01:05 UTC
Mehmet Ince: Part 2/6 | Breaking the Postgres Superuser Guardrails: Attacking Security-Hardening Extensions |Systemic Risks in the Managed PostgreSQL Industry
It’s been a month since I published the first part of this research, and interest from the Postgres community has been higher than I expected...
23 September 2026 01:00 UTC
Christophe Pettus: All Your GUCs in a Row: max_pred_locks_per_transaction
max_pred_locks_per_transaction has the naming problem of max_locks_per_transaction, and then one of its own. Like its namesake, it is a table size...
news feed via Planet PostgreSQL.
