Content-Type: multipart/mixed; boundary="------------ED4frLisz0A0UpAKWTKLhPLm"
Message-ID: <78b34e84-2195-4f28-a151-5d204a382fdd@oss.nttdata.com>
Date: Thu, 26 Jun 2025 01:25:56 +0900
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Content-Language: en-US
To: pgsql-docs@lists.postgresql.org
From: Fujii Masao <masao.fujii@oss.nttdata.com>
Subject: Mention idle_replication_slot_timeout in pg_replication_slots docs
Archived-At: 
 <https://www.postgresql.org/message-id/78b34e84-2195-4f28-a151-5d204a382fdd%40oss.nttdata.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------ED4frLisz0A0UpAKWTKLhPLm
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

The pg_replication_slots documentation mentions only max_slot_wal_keep_size
as a condition under which the wal_status column can show unreserved or lost.
However, since commit ac0e33136ab, idle_replication_slot_timeout can also
cause this behavior when it is set. This has not been documented yet.
https://www.postgresql.org/docs/devel/view-pg-replication-slots.html

So, how about updating the documentation to also mention
idle_replication_slot_timeout as a factor that can cause wal_status to
become unreserved or lost? Patch attached.

Regards,

-- 
Fujii Masao
NTT DATA Japan Corporation

--------------ED4frLisz0A0UpAKWTKLhPLm
Content-Type: text/plain; charset=UTF-8;
 name="v1-0001-doc-Mention-idle_replication_slot_timeout-in-pg_r.patch"
Content-Disposition: attachment;
 filename*0="v1-0001-doc-Mention-idle_replication_slot_timeout-in-pg_r.pa";
 filename*1="tch"
Content-Transfer-Encoding: base64

RnJvbSA3YmNjYjE2YzExMTllMDAxOTQ5MzlkZmUxNTRkMWFhMGU4ZDE5ODQyIE1vbiBTZXAg
MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBGdWppaSBNYXNhbyA8ZnVqaWlAcG9zdGdyZXNxbC5v
cmc+CkRhdGU6IFRodSwgMjYgSnVuIDIwMjUgMDA6NTU6NDYgKzA5MDAKU3ViamVjdDogW1BB
VENIIHYxXSBkb2M6IE1lbnRpb24gaWRsZV9yZXBsaWNhdGlvbl9zbG90X3RpbWVvdXQgaW4K
IHBnX3JlcGxpY2F0aW9uX3Nsb3RzIGRvY3MuCgpUaGUgcGdfcmVwbGljYXRpb25fc2xvdHMg
ZG9jdW1lbnRhdGlvbiBwcmV2aW91c2x5IG1lbnRpb25lZCBvbmx5Cm1heF9zbG90X3dhbF9r
ZWVwX3NpemUgYXMgYSBjb25kaXRpb24gdW5kZXIgd2hpY2ggdGhlIHdhbF9zdGF0dXMgY29s
dW1uCmNhbiBzaG93IHVucmVzZXJ2ZWQgb3IgbG9zdC4gSG93ZXZlciwgc2luY2UgY29tbWl0
IGFjMGUzMzEzNmFiLAppZGxlX3JlcGxpY2F0aW9uX3Nsb3RfdGltZW91dCBjYW4gYWxzbyBj
YXVzZSB0aGlzIGJlaGF2aW9yIHdoZW4gaXQgaXMgc2V0LgpUaGlzIHdhcyBub3QgZG9jdW1l
bnRlZC4KClRoaXMgY29tbWl0IHVwZGF0ZXMgdGhlIGRvY3VtZW50YXRpb24gdG8gYWxzbyBt
ZW50aW9uCmlkbGVfcmVwbGljYXRpb25fc2xvdF90aW1lb3V0IGFzIGEgZmFjdG9yIHRoYXQg
Y2FuIGNhdXNlIHdhbF9zdGF0dXMKdG8gYmVjb21lIHVucmVzZXJ2ZWQgb3IgbG9zdC4KLS0t
CiBkb2Mvc3JjL3NnbWwvc3lzdGVtLXZpZXdzLnNnbWwgfCA1ICsrKy0tCiAxIGZpbGUgY2hh
bmdlZCwgMyBpbnNlcnRpb25zKCspLCAyIGRlbGV0aW9ucygtKQoKZGlmZiAtLWdpdCBhL2Rv
Yy9zcmMvc2dtbC9zeXN0ZW0tdmlld3Muc2dtbCBiL2RvYy9zcmMvc2dtbC9zeXN0ZW0tdmll
d3Muc2dtbAppbmRleCA5ODZhZTFmNTQzZC4uZjk3ZGE5ZjdlNjEgMTAwNjQ0Ci0tLSBhL2Rv
Yy9zcmMvc2dtbC9zeXN0ZW0tdmlld3Muc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvc3lzdGVt
LXZpZXdzLnNnbWwKQEAgLTI4MzIsOCArMjgzMiw5IEBAIFNFTEVDVCAqIEZST00gcGdfbG9j
a3MgcGwgTEVGVCBKT0lOIHBnX3ByZXBhcmVkX3hhY3RzIHBweAogICAgICAgIDwvaXRlbWl6
ZWRsaXN0PgogICAgICAgIFRoZSBsYXN0IHR3byBzdGF0ZXMgYXJlIHNlZW4gb25seSB3aGVu
CiAgICAgICAgPHhyZWYgbGlua2VuZD0iZ3VjLW1heC1zbG90LXdhbC1rZWVwLXNpemUiLz4g
aXMKLSAgICAgICBub24tbmVnYXRpdmUuIElmIDxzdHJ1Y3RmaWVsZD5yZXN0YXJ0X2xzbjwv
c3RydWN0ZmllbGQ+IGlzIE5VTEwsIHRoaXMKLSAgICAgICBmaWVsZCBpcyBudWxsLgorICAg
ICAgIG5vbi1uZWdhdGl2ZSBhbmQvb3IgPHhyZWYgbGlua2VuZD0iZ3VjLWlkbGUtcmVwbGlj
YXRpb24tc2xvdC10aW1lb3V0Ii8+CisgICAgICAgaXMgZ3JlYXRlciB0aGFuIHplcm8uIElm
IDxzdHJ1Y3RmaWVsZD5yZXN0YXJ0X2xzbjwvc3RydWN0ZmllbGQ+IGlzIE5VTEwsCisgICAg
ICAgdGhpcyBmaWVsZCBpcyBudWxsLgogICAgICAgPC9wYXJhPjwvZW50cnk+CiAgICAgIDwv
cm93PgogCi0tIAoyLjQ5LjAKCg==

--------------ED4frLisz0A0UpAKWTKLhPLm--