Life with Open Source

PostgreSQL 19.0 (upcoming) commit log

by Yogesh Sharma

Restrict pg_stat_io entries for data checksum processes

commit   : 3aa54433b0cdce48facb610a5b720208cc760654    
  
author   : Fujii Masao <fujii@postgresql.org>    
date     : Fri, 17 Jul 2026 20:16:34 +0900    
  
committer: Fujii Masao <fujii@postgresql.org>    
date     : Fri, 17 Jul 2026 20:16:34 +0900

Click here for diff

The data checksums launcher and workers were exposed in pg_stat_io  
with the same broad set of object/context combinations as general  
background workers. However, several of those entries can never  
accumulate I/O statistics for these processes, such as bulkwrite,  
relation init, temporary relation, and launcher vacuum entries.  
  
Teach pgstat_tracks_io_object() and pgstat_tracks_io_op() about the  
actual I/O performed by the data checksum processes. Keep the entries  
needed for catalog scans, including bulkread catalog scans, worker  
relation processing with a vacuum access strategy, and WAL writes and  
initialization, while excluding WAL reads and other object/context  
combinations that can never be used.  
  
Author: Fujii Masao <masao.fujii@gmail.com>  
Reviewed-by: Daniel Gustafsson <daniel@yesql.se>  
Discussion: https://postgr.es/m/CAHGQGwHz_-nt+YkHDMRZNBZrnoHro8cMOgSwuXEmSYT6vxgQ=w@mail.gmail.com  
Backpatch-through: 19

M src/backend/utils/activity/pgstat_io.c
M src/test/regress/expected/stats.out

PostgreSQL 20.0 (upcoming) commit log

by Yogesh Sharma

Restrict pg_stat_io entries for data checksum processes

commit   : 32e4508db27d1fa3dc07404ad69d43ed97870f15    
  
author   : Fujii Masao <fujii@postgresql.org>    
date     : Fri, 17 Jul 2026 20:16:34 +0900    
  
committer: Fujii Masao <fujii@postgresql.org>    
date     : Fri, 17 Jul 2026 20:16:34 +0900

Click here for diff

The data checksums launcher and workers were exposed in pg_stat_io  
with the same broad set of object/context combinations as general  
background workers. However, several of those entries can never  
accumulate I/O statistics for these processes, such as bulkwrite,  
relation init, temporary relation, and launcher vacuum entries.  
  
Teach pgstat_tracks_io_object() and pgstat_tracks_io_op() about the  
actual I/O performed by the data checksum processes. Keep the entries  
needed for catalog scans, including bulkread catalog scans, worker  
relation processing with a vacuum access strategy, and WAL writes and  
initialization, while excluding WAL reads and other object/context  
combinations that can never be used.  
  
Author: Fujii Masao <masao.fujii@gmail.com>  
Reviewed-by: Daniel Gustafsson <daniel@yesql.se>  
Discussion: https://postgr.es/m/CAHGQGwHz_-nt+YkHDMRZNBZrnoHro8cMOgSwuXEmSYT6vxgQ=w@mail.gmail.com  
Backpatch-through: 19

M src/backend/utils/activity/pgstat_io.c
M src/test/regress/expected/stats.out

PostgreSQL 14.23 commit log

by Yogesh Sharma

Stamp 14.23.

commit   : 4e1a23c0ea0be0214c6806baa212886cee8f14a6    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 15:51:39 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 15:51:39 -0400

Click here for diff

M configure
M configure.ac

Last-minute updates for release notes.

commit   : 93741c9db09709ebe05d5f59ee7852c3ad4981a9    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 14:54:40 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 14:54:40 -0400

Click here for diff

PostgreSQL 15.18 commit log

by Yogesh Sharma

Stamp 15.18.

commit   : 005c1971a2926fbb9caf5a1ad634cd17a42bfd3c    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 15:49:58 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 15:49:58 -0400

Click here for diff

M configure
M configure.ac

Last-minute updates for release notes.

commit   : 78f1b471f991307cea4aa0d95f2d957601a1b8cd    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 14:54:40 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 14:54:40 -0400

Click here for diff

PostgreSQL 16.14 commit log

by Yogesh Sharma

Stamp 16.14.

commit   : 0d1c00c624fa7367d4a895f44381887757289682    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 15:48:18 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 15:48:18 -0400

Click here for diff

M configure
M configure.ac
M meson.build

Last-minute updates for release notes.

commit   : 878e171244f7c1280201a04aa420b78c4a2d08d3    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 14:54:40 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 14:54:40 -0400

Click here for diff

PostgreSQL 17.10 commit log

by Yogesh Sharma

Stamp 17.10.

commit   : 25c49f3a4a742ba283f5cc43cc7f1d361552e917    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 15:46:41 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 15:46:41 -0400

Click here for diff

M configure
M configure.ac
M meson.build

Last-minute updates for release notes.

commit   : 25d938dbcb19ba172068159c0f22826d7cc681ea    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 14:54:40 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 14:54:40 -0400

Click here for diff

PostgreSQL 18.4 commit log

by Yogesh Sharma

Stamp 18.4.

commit   : f5cc81719e6da4cbdb1f797c48b693e91018153a    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 15:44:35 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 15:44:35 -0400

Click here for diff

M configure
M configure.ac
M meson.build

Last-minute updates for release notes.

commit   : bbd12e8010561dab2c745d2ece0e94d102bef2ea    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 14:54:40 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 14:54:40 -0400

Click here for diff

PostgreSQL 14.22 commit log

by Yogesh Sharma

Stamp 14.22.

commit   : 966473719c7f8067848dc79b58da0fb17ed136b1    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 23 Feb 2026 17:03:30 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 23 Feb 2026 17:03:30 -0500

Click here for diff

M configure
M configure.ac

Translation updates

commit   : 7917762558545fbe16c0c9e9b97b83a30c11eaa8    
  
author   : Peter Eisentraut <peter@eisentraut.org>    
date     : Mon, 23 Feb 2026 14:06:33 +0100    
  
committer: Peter Eisentraut <peter@eisentraut.org>    
date     : Mon, 23 Feb 2026 14:06:33 +0100

Click here for diff

PostgreSQL 15.17 commit log

by Yogesh Sharma

Stamp 15.17.

commit   : 3eb6f61958ac5027a18791a828a0c7a47accf211    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 23 Feb 2026 17:01:47 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 23 Feb 2026 17:01:47 -0500

Click here for diff

M configure
M configure.ac

Translation updates

commit   : 7063b9e92b25caaa27c8cc4ec37ef85fe9e63cb7    
  
author   : Peter Eisentraut <peter@eisentraut.org>    
date     : Mon, 23 Feb 2026 14:03:47 +0100    
  
committer: Peter Eisentraut <peter@eisentraut.org>    
date     : Mon, 23 Feb 2026 14:03:47 +0100

Click here for diff

PostgreSQL 16.13 commit log

by Yogesh Sharma

Stamp 16.13.

commit   : 776479eed63aac4185e57adaf7db1ce0810a4d3e    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 23 Feb 2026 17:00:20 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 23 Feb 2026 17:00:20 -0500

Click here for diff

M configure
M configure.ac
M meson.build

Translation updates

commit   : 96802648aa2fc114f1d8728540494e422059b9ab    
  
author   : Peter Eisentraut <peter@eisentraut.org>    
date     : Mon, 23 Feb 2026 14:02:22 +0100    
  
committer: Peter Eisentraut <peter@eisentraut.org>    
date     : Mon, 23 Feb 2026 14:02:22 +0100

Click here for diff