Re: New WAL record to detect the checkpoint redo location

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: New WAL record to detect the checkpoint redo location
Date: 2023-10-18 14:24:50
Message-ID: CA+TgmoYV0+U94mU2O2agx03AVzmK81w7uv98_6N5ciguc3VF-A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Oct 17, 2023 at 8:35 PM Michael Paquier <michael(at)paquier(dot)xyz> wrote:
> Suggestion is from here, with a test for pg_walinspect after it runs
> its online checkpoint (see the full-page case):
> https://www.postgresql.org/message-id/ZOvf1tu6rfL/B2PW(at)paquier(dot)xyz
>
> +-- Check presence of REDO record.
> +SELECT redo_lsn FROM pg_control_checkpoint() \gset
> +SELECT start_lsn = :'redo_lsn'::pg_lsn AS same_lsn, record_type
> + FROM pg_get_wal_record_info(:'redo_lsn');

I added a variant of this test case. Here's v10.

--
Robert Haas
EDB: http://www.enterprisedb.com

Attachment Content-Type Size
v10-0001-During-online-checkpoints-insert-XLOG_CHECKPOINT.patch application/octet-stream 18.6 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2023-10-18 14:27:59 Re: Query execution in Perl TAP tests needs work
Previous Message Robert Haas 2023-10-18 14:07:46 Re: run pgindent on a regular basis / scripted manner