Re: Online enabling of checksums
Andres Freund <andres@anarazel.de>
From: Andres Freund <andres@anarazel.de>
To: pgsql-hackers@lists.postgresql.org,Magnus Hagander <magnus@hagander.net>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>,PostgreSQL-development
<pgsql-hackers@postgresql.org>,Daniel Gustafsson <daniel@yesql.se>
Date: 2018-02-22T19:52:20Z
Lists: pgsql-hackers
On February 22, 2018 11:44:17 AM PST, Magnus Hagander <magnus@hagander.net> wrote: >On Thu, Feb 22, 2018 at 8:41 PM, Andres Freund <andres@anarazel.de> >wrote: >In this particular case that would at least phase 1 simplify it because >we'd only need one process instead of worker/launcher. However, if we'd >ever want to parallellize it -- or any other process of the style, like >autovacuum -- you'd still need a launcher+worker combo. So making that >particular scenario simpler might be worthwhile on it's own. Why is that needed? You can just start two bgworkers and process a list of items stored in shared memory. Or even just check, I assume there'd be a catalog flag somewhere, whether a database / table / object of granularity has already been processed and use locking to prevent concurrent access. Andres -- Sent from my Android device with K-9 Mail. Please excuse my brevity.
Commits
-
Online enabling and disabling of data checksums
- f19c0eccae96 19 (unreleased) landed
-
Deactive flapping checksum isolation tests.
- bf75fe47e444 11.0 landed
-
Add support for coordinating record typmods among parallel workers.
- cc5f81366c36 11.0 cited