| 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
| 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. |