Re: Changing the state of data checksums in a running cluster

Daniel Gustafsson <daniel@yesql.se>

From: Daniel Gustafsson <daniel@yesql.se>

To: Heikki Linnakangas <hlinnaka@iki.fi>

Cc: Tomas Vondra <tomas@vondra.me>, Andres Freund <andres@anarazel.de>, Bernd Helmle <mailings@oopsware.de>, Michael Paquier <michael@paquier.xyz>, Michael Banck <mbanck@gmx.net>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2026-03-31T12:42:32Z

Lists: pgsql-hackers

Attachments

v20260331-0001-Online-enabling-and-disabling-of-data-chec.patch (application/octet-stream) patch v20260331-0001

> On 29 Mar 2026, at 00:14, Daniel Gustafsson <daniel@yesql.se> wrote:
> 
>> On 28 Mar 2026, at 00:30, Heikki Linnakangas <hlinnaka@iki.fi> wrote:
> 
>> +1 for committing 0001 right away.
> 
> Thanks for confirming, I'll do that early next week.

Done in 097ab69d17f74e.

The attached rebase fixes the silly mistake which made it fail on CI under
Linux: when enabling all tests under normal non-PG_TEST_EXTRA runs I had
rebased away my change to drop the scalefactor down, so the Linux boxes ran out
of diskspace.  Reducing the scalefactor to also allow the test to run faster
made CI green for me.

--
Daniel Gustafsson

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Use correct datatype for PID
- 0ca1b3010597 19 (unreleased) landed
Improve comments in online checksums code
- cd857dec0e0a 19 (unreleased) landed
Fix checksum state transition during promotion
- 5fee7cab1b87 19 (unreleased) landed
Fix regex searching for page verification failures in tests
- 486b9a9b9eb4 19 (unreleased) landed
Apply data-checksum worker throttling parameters
- 9a39056c418c 19 (unreleased) landed
Skip WAL for unlogged main fork during online checksum enable
- 2018bd616790 19 (unreleased) landed
Fix data_checksum GUC show_hook
- 75152c5dc5d3 19 (unreleased) landed
Improve database detection logic in datachecksumsworker
- 1df361e3d82c 19 (unreleased) landed
Improve handling of concurrent checksum requests
- bf25e5571b32 19 (unreleased) landed
Typo and spelling fixups for online checksums
- 381d19da1536 19 (unreleased) landed
Fix invalid checksum state transition in checkpoints
- 25b922ec5825 19 (unreleased) landed
Handle data_checksum state changes during launcher_exit
- 8fb8ded88956 19 (unreleased) landed
Test improvements for online checksums
- a0d8f4c1ae16 19 (unreleased) landed
Prevent pg_enable/disable_data_checksums() on standby
- b120358c612d 19 (unreleased) landed
Test stabilization for online checksums
- 07009121c235 19 (unreleased) landed
Make data checksum tests more resilient for slow machines
- 0036232ba8fb 19 (unreleased) landed
Formalize WAL record for XLOG_CHECKPOINT_REDO
- 097ab69d17f7 19 (unreleased) landed
Revert "Get rid of WALBufMappingLock"
- c13070a27b63 19 (unreleased) cited
Get rid of WALBufMappingLock
- bc22dc0e0ddc 18.0 cited
Improve grammar of options for command arrays in TAP tests
- ce1b0f9da03e 18.0 cited