Support asynchronous execution of MergeAppend subplans.
commit : 11591f273e6a26fb55728b410538fa2627b19b28
author : Etsuro Fujita <efujita@postgresql.org>
date : Tue, 17 Nov 2026 15:30:00 +0900
committer: Etsuro Fujita <efujita@postgresql.org>
date : Tue, 17 Nov 2026 15:30:00 +0900
Click here for diff
Commit 27e1f1456 added asynchronous execution for Append nodes, letting
multiple async-capable children -- in practice postgres_fdw ForeignScans
-- run concurrently instead of one at a time, but MergeAppend was not
covered.
This commit extends asynchronous execution to MergeAppend. On the first
call, requests for all valid async subplans are fired off up front, the
synchronous subplans are pulled while those requests are in flight, and
the async results are then collected before the merge heap is built.
After that, the merge cannot emit another row until the next tuple from
one specific subplan (the current heap top) is known, so at most one
request is outstanding during steady-state execution, and we always wait
indefinitely for it rather than polling as Append does.
Some other notable changes to the core and postgres_fdw code:
* create_merge_append_plan now marks children async-capable. Unlike a
plain Append, which disables async whenever its output must be
ordered, a MergeAppend always has pathkeys and still preserves
ordering by merging the per-child streams, so having pathkeys is not
disqualifying here; a child is eligible only if it is ordered well
enough on its own that no Sort node was inserted above it, as Sort is
not async-capable. The new GUC enable_async_merge_append (default on)
controls this.
* The event-loop body of ExecAppendAsyncEventWait is factored out into a
new ExecAsyncEventWait in execAsync.c and shared by both node types,
with the caller responsible for creating and freeing the WaitEventSet.
A new MergeAppendReady wait event reports waits in the new event loop.
* Since an FDW's ForeignAsyncConfigureWait callback can no longer assume
the requestor is an Append, add ExecAsyncGetRequestorEventSet to fetch
the requestor's WaitEventSet without knowing its node type, and use it
in postgres_fdw.
* postgresForeignAsyncConfigureWait also needs adjusting: the
optimization of skipping event configuration, rather than processing
an in-progress request made by a different requestor, is valid only
when our requestor is an Append; a MergeAppend cannot make progress
unless the given request produces a result, so in that case we process
the pending request and configure the event.
Full disclosure: I (Etsuro) reworked Alexander Pyhalov's original patch
with Claude Opus 4.8.
Author: Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Author: Etsuro Fujita <etsuro.fujita@gmail.com>
Reviewed-by: Matheus Alcantara <matheusssilv97@gmail.com>
Reviewed-by: Alexander Korotkov <aekorotkov@gmail.com>
Reviewed-by: Alena Rybakina <a.rybakina@postgrespro.ru>
Reviewed-by: Álvaro Herrera <alvherre@kurilemu.de>
Reviewed-by: solai v <solai.cdac@gmail.com>
Reviewed-by: Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Reviewed-by: Etsuro Fujita <etsuro.fujita@gmail.com>
Discussion: https://postgr.es/m/59be194c5a409fb9fc9f2031581b8a44%40postgrespro.ru
M contrib/postgres_fdw/expected/postgres_fdw.out
M contrib/postgres_fdw/postgres_fdw.c
M contrib/postgres_fdw/sql/postgres_fdw.sql
M doc/src/sgml/config.sgml
M doc/src/sgml/fdwhandler.sgml
M doc/src/sgml/postgres-fdw.sgml
M src/backend/executor/README
M src/backend/executor/execAsync.c
M src/backend/executor/nodeAppend.c
M src/backend/executor/nodeMergeAppend.c
M src/backend/optimizer/path/costsize.c
M src/backend/optimizer/plan/createplan.c
M src/backend/utils/activity/wait_event_names.txt
M src/backend/utils/misc/guc_parameters.dat
M src/backend/utils/misc/postgresql.conf.sample
M src/include/executor/execAsync.h
M src/include/executor/nodeMergeAppend.h
M src/include/nodes/execnodes.h
M src/include/optimizer/cost.h
M src/test/regress/expected/sysviews.out
Stamp 19.0.
commit : 5c839a2a08b9b87a349be97371fac6c5a2873b10
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 16 Nov 2026 15:02:58 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 16 Nov 2026 15:02:58 -0500
Click here for diff
M configure
M configure.ac
M meson.build
Translation updates
commit : 7f40ddf3cf6e89eecb225e374928ce3991d45012
author : Álvaro Herrera <alvherre@kurilemu.de>
date : Mon, 16 Nov 2026 10:40:01 +0100
committer: Álvaro Herrera <alvherre@kurilemu.de>
date : Mon, 16 Nov 2026 10:40:01 +0100
Click here for diff
v2.60.1: Annotate and SFTP Fixes
commit : 7aeba299c49abd768ca741506569007a5cab0870
author : David Steele <david@pgbackrest.org>
date : Mon, 16 Nov 2026 08:49:15 -0300
committer: David Steele <david@pgbackrest.org>
date : Mon, 16 Nov 2026 08:49:15 -0300
Click here for diff
Bug Fixes:
* Fix annotate saving backup.info to the default repository. (Reviewed by Stefan Fercot, Douglas J Hunley.)
* Fix possible block incremental restore failure on SFTP storage. (Reviewed by Douglas J Hunley. Reported by Fineline19.)
* Fix use of SFTP file handles after a reconnect. (Reviewed by Douglas J Hunley.)
* Fix excessive memory use by the memory context free list. (Fixed by Vasiliy Koshkin. Reviewed by David Steele, Douglas J Hunley.)
* Do not lower a minimum TLS version set by the OpenSSL config. (Reviewed by Douglas J Hunley, Stefan Fercot.)
* Fix reporting of OpenSSL errors. (Reviewed by Douglas J Hunley, Stefan Fercot.)
Documentation Improvements:
* Document TLS settings skipped when repo-storage-verify-tls=n.
M CONTRIBUTING.md
M README.md
M doc/resource/exe.cache
M doc/xml/auto/metric-coverage-report.auto.xml
M doc/xml/news.xml
M doc/xml/release/2020s/2026/2.59.2.xml
M doc/xml/release/2020s/2026/2.60.1.xml
M meson.build
M src/version.h
Stamp 14.25.
commit : 9adcf5f8847e0f485a390b1d3ea40688068d71bd
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 Nov 2026 15:16:32 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 Nov 2026 15:16:32 -0500
Click here for diff
M configure
M configure.ac
Last-minute updates for release notes.
commit : 1a6533506b3e6639fe6e48ee881b31aa76bfca54
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 Nov 2026 12:43:05 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 Nov 2026 12:43:05 -0500
Click here for diff
Stamp 15.20.
commit : 6a84c5137e820f46f0123276f546eec5b9a56e70
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 Nov 2026 15:14:54 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 Nov 2026 15:14:54 -0500
Click here for diff
M configure
M configure.ac
Last-minute updates for release notes.
commit : 588ac6507696303da5ca645460ebcd7b11659a82
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 Nov 2026 12:43:05 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 Nov 2026 12:43:05 -0500
Click here for diff
Stamp 16.16.
commit : c0534eb02de050ac1035ad7b3ad7c3f02980f153
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 Nov 2026 15:12:54 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 Nov 2026 15:12:54 -0500
Click here for diff
M configure
M configure.ac
M meson.build
Last-minute updates for release notes.
commit : b72e2acba126f06ba0a36436af0fafce2bd4e19d
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 Nov 2026 12:43:05 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 Nov 2026 12:43:05 -0500
Click here for diff
Stamp 17.12.
commit : 702b3dc86d35bcc08c8e23cffa3c4d9fe9d32c85
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 Nov 2026 15:11:08 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 Nov 2026 15:11:08 -0500
Click here for diff
M configure
M configure.ac
M meson.build
Last-minute updates for release notes.
commit : 18c4a9c5f66a1fdf02be21751b931338a04d5790
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 Nov 2026 12:43:05 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 Nov 2026 12:43:05 -0500
Click here for diff
Stamp 18.7.
commit : f5c41f6681c910b3f69951bf6fb97c6d74605d25
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 Nov 2026 15:09:29 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 Nov 2026 15:09:29 -0500
Click here for diff
M configure
M configure.ac
M meson.build
Last-minute updates for release notes.
commit : aed4c42bce80dda767277cf983baec4678c55daf
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 Nov 2026 12:43:05 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 Nov 2026 12:43:05 -0500
Click here for diff
v2.60.0: Page Checksum Errors and Object Store Prefetch
commit : 2e1c4f2ba727c45a0a23d4b326905088dc15b1a1
author : David Steele <david@pgbackrest.org>
date : Sun, 18 Oct 2026 10:31:33 +0200
committer: David Steele <david@pgbackrest.org>
date : Sun, 18 Oct 2026 10:31:33 +0200
Click here for diff
IMPORTANT NOTE: The restore command will now error and stop if any restored file contains an invalid page checksum, which leaves the cluster incomplete and unable to start, so the restore must be rerun. The expire command will now refuse to expire if the oldest retained backup would contain checksum errors, which also prevents archive from being expired in that repository. Set checksum-page-error=n to warn instead of erroring.
Features:
* Add checksum-page-error option to error on invalid page checksums. (Contributed by Andrew Pogrebnoi. Reviewed by Douglas J Hunley, David Steele, Greg Sabino Mullane, Stefan Fercot. Suggested by Greg Sabino Mullane.)
* Support for GCS Workload Identity Federation. (Contributed by Adol Rodriguez. Reviewed by Douglas J Hunley, David Steele.)
* Prefetch multi-file/range reads from object stores. (Reviewed by Andrew Pogrebnoi, Douglas J Hunley.)
Improvements:
* Reduce keep-alive requests to remote processes. (Reviewed by Douglas J Hunley.)
* Retry Azure batch sub-requests missing from the response. (Reviewed by Douglas J Hunley.)
* Reduce the manifest checks made when reconstructing backup.info. (Reviewed by Douglas J Hunley. Suggested by todeb.)
* Use original size to determine if a file should be bundled. (Reviewed by Douglas J Hunley.)
* Add context to block map read errors during backup. (Reviewed by Stefan Fercot, Douglas J Hunley.)
* Cast current_timestamp to text in the backup start label. (Contributed by Tiago Corcelli de Oliveira. Reviewed by David Steele.)
* Support building on illumos. (Contributed by Kalevi Kolttonen. Reviewed by Douglas J Hunley, David Steele.)
* Support OpenSSL 4. (Reviewed by Douglas J Hunley.)
* Fix clang builds. (Reviewed by Douglas J Hunley.)
* Migrate code generation from C to Python.
Documentation Improvements:
* Modernize the website. Special thanks to Jan for the insightful (and hilarious) logo. (Contributed by David Steele, Jan Wieremjewicz. Reviewed by Steve Atkins, Kai Wagner, Douglas J Hunley, Nikolaos Stamatopoulos, Matt Hudson, Stefan Fercot.)
* Document the release schedule.
* Migrate the documentation tools from C and Perl to Python.
Test Suite Improvements:
* Migrate the test harness from C and Perl to Python.
* Add a Fil-C job to CI.
* Add fuzz testing for the JSON, Ini, and Pack readers.
* Allow test user names that adduser on Debian rejects. (Contributed by Stefan Fercot. Reviewed by David Steele.)
M CONTRIBUTING.md
M README.md
M doc/resource/exe.cache
M doc/xml/auto/metric-coverage-report.auto.xml
M doc/xml/index.xml
M doc/xml/news.xml
M doc/xml/release/2020s/2026/2.59.0.xml
M doc/xml/release/2020s/2026/2.59.2.xml
M doc/xml/release/2020s/2026/2.60.0.xml
M meson.build
M src/version.h
v2.59.3: Weak Encryption Subkey Bug
commit : 46cdca625a73403cad4774d97354a1fac1e91e51
author : David Steele <david@pgbackrest.org>
date : Sun, 4 Oct 2026 09:29:49 +0200
committer: David Steele <david@pgbackrest.org>
date : Sun, 4 Oct 2026 09:29:49 +0200
Click here for diff
IMPORTANT NOTE: In prior versions it was possible for weak encryption subkeys and salts to be generated if there was an error accessing system random data.
Bug Fixes:
* Fix possible checksum error loading encrypted info and manifest files. (Fixed by j0uinim. Reviewed by David Steele.)
* Fix possible weak encryption subkeys/salts. (Fixed by j0uinim. Reviewed by David Steele, Stefan Fercot, Douglas J Hunley.)
M CONTRIBUTING.md
M README.md
M doc/RELEASE.md
M doc/resource/exe.cache
M doc/resource/git-history.cache
M doc/xml/auto/metric-coverage-report.auto.xml
M doc/xml/index.xml
M doc/xml/news.xml
M doc/xml/release/2020s/2026/2.59.3.xml
M meson.build
M src/version.h