From 3e77b2eb3466aff9fe19e209ebc0d899ea869494 Mon Sep 17 00:00:00 2001 From: Amit Kapila Date: Fri, 4 Nov 2022 09:00:46 +0530 Subject: [PATCH] Doc: Improve the description of confirmed_flush_lsn in pg_replication_slots. Make it clear that the data corresponding to the transactions committed before confirmed_flush_lsn is not available anymore. Author: Ashutosh Sharma Reviewd by: Ashutosh Bapat Discussion: https://postgr.es/m/CAE9k0P=hiqRXUonnmtS-5Pu8SbO=yF6vcrVBcfEf2+93ng_f5Q@mail.gmail.com --- doc/src/sgml/system-views.sgml | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/system-views.sgml b/doc/src/sgml/system-views.sgml index 947598e7e7e..7c716fe3276 100644 --- a/doc/src/sgml/system-views.sgml +++ b/doc/src/sgml/system-views.sgml @@ -2413,8 +2413,9 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx The address (LSN) up to which the logical - slot's consumer has confirmed receiving data. Data older than this is - not available anymore. NULL for physical slots. + slot's consumer has confirmed receiving data. Data corresponding to the + transactions committed before this LSN is not + available anymore. NULL for physical slots. -- 2.39.5