RE: Newly created replication slot may be invalidated by checkpoint

From: "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>
To: "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: vignesh C <vignesh21(at)gmail(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Vitaly Davydov <v(dot)davydov(at)postgrespro(dot)ru>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, suyu(dot)cmj <mengjuan(dot)cmj(at)alibaba-inc(dot)com>, tomas <tomas(at)vondra(dot)me>, michael <michael(at)paquier(dot)xyz>, bharath(dot)rupireddyforpostgres <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, Alexander Korotkov <aekorotkov(at)gmail(dot)com>
Subject: RE: Newly created replication slot may be invalidated by checkpoint
Date: 2026-01-22 06:53:47
Message-ID: TY7PR01MB1455450692BE259E3E26C9480F597A@TY7PR01MB14554.jpnprd01.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Dear Hou,

Thanks for updating the patch. Further comments.

01.
```
+#include "access/xlog.h"
```

I could build without the inclusion because "replication/logical.h" already
includes it. Can we remove or we should retain?

02.
Should we increase checkpoint_timeout for stabilizing tests?

03.
To confirm, you've removed the logic that checks the oldest segment and try
reserving, but it can be removed same as ReplicationSlotReserveWal(), right?
XLogGetOldestSegno() is also not needed anymore because race can't happen if standby have never discarded.

04.
```
$primary->psql('postgres',
q{SELECT pg_create_logical_replication_slot('failover_slot', 'test_decoding', false, false, true);
SELECT pg_create_physical_replication_slot('phys_slot');}
);
...
$primary->psql('postgres', "CHECKPOINT");
```

I found two lines use `psql()`, but should be `safe_psql()`.

05.
Per my tests, the issue exists till PG17 and your patch can be backpatched till
it, right?

Best regards,
Hayato Kuroda
FUJITSU LIMITED

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message wenhui qiu 2026-01-22 06:58:29 Re: Report oldest xmin source when autovacuum cannot remove tuples
Previous Message Michael Paquier 2026-01-22 06:51:29 Re: [PATCH v1] Document pg_get_partition_constraintdef.