Life with Open Source

PostgreSQL 20.0 (upcoming) commit log

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

PostgreSQL 19.0 (upcoming) commit log

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

pgBackRest 2.70 commit log

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

PostgreSQL 14.25 commit log

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

PostgreSQL 15.20 commit log

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

PostgreSQL 16.16 commit log

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

PostgreSQL 17.12 commit log

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

PostgreSQL 18.6 commit log

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

pgBackRest 2.69 commit log

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

pgBackRest 2.68 commit log

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