pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Robert Haas <rhaas@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Allow WAL summarization to back up when timeline changes.
Date: Fri, 26 Jul 2024 14:09:01 +0000
Message-ID: <E1sXLcz-001Jhw-Af@gemulon.postgresql.org> (raw)

Allow WAL summarization to back up when timeline changes.

The old code believed that it was not possible to switch timelines
without first replaying all of the WAL from the old timeline, but
that turns out to be false, as demonstrated by an example from Fujii
Masao. As a result, it assumed that summarization would always
continue from the LSN where summarization previously ended. But in
fact, when a timeline switch occurs without replaying all the WAL
from the previous timeline, we can need to back up to an earlier
LSN. Adjust accordingly.

Discussion: https://postgr.es/m/CA+TgmoZGEsZodXC4f=XZNkAeyuDmWTSkpkjCEOcF19Am0mt_OA@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/cf8a4898360bbb70a0f9eec7bac8bcb4fcb7aa42

Modified Files
--------------
src/backend/postmaster/walsummarizer.c | 32 +++++++++++++++++++-------------
1 file changed, 19 insertions(+), 13 deletions(-)



view thread (2+ messages)  latest in thread

Message-ID: <E1sXLcz-001Jhw-Af@gemulon.postgresql.org>
Permalink:  ../E1sXLcz-001Jhw-Af@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1sXLcz-001Jhw-Af@gemulon.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: rhaas@postgresql.org, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Allow WAL summarization to back up when timeline changes.
  In-Reply-To: <E1sXLcz-001Jhw-Af@gemulon.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox