pgexperts.com

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.

Let us know how we can help.

Recent Talks

Latest Commit

26 August 2026 05:19 UTC

Remove the redundant remote_final_lsn variable from the apply worker.

The apply worker tracked the final LSN of the remote transaction being applied in a separate global variable remote_final_lsn, even though apply_error_callback_arg already tracked the same transaction's xid and finish LSN for error context reporting, and both were updated together at the same places.

Rename ApplyErrorCallbackArg to ApplyRemoteCtx and treat its remote_xid/finish_lsn pair as the generic descriptor of the remote transaction currently being applied, replacing all uses of remote_final_lsn so the redundant global can be removed.

There is no behavior change.

Recording the remote transaction being applied in a single place should also help the proposed conflict log table patch, which needs the same information when logging a conflict.

PostgreSQL News

Read the original on pgexperts.com ↗