On Mon, Sep 19, 2022 at 1:43 PM Ashutosh Sharma <ashu.coe...@gmail.com> wrote: > > On Fri, Sep 9, 2022 at 5:36 PM Ashutosh Bapat > <ashutosh.bapat....@gmail.com> wrote: > > > > On Thu, Sep 8, 2022 at 8:32 PM Ashutosh Sharma <ashu.coe...@gmail.com> > > wrote: > > > > > > On Thu, Sep 8, 2022 at 6:23 PM Ashutosh Bapat > > > <ashutosh.bapat....@gmail.com> wrote: > > > > > > > > On Thu, Sep 8, 2022 at 4:14 PM Ashutosh Sharma <ashu.coe...@gmail.com> > > > > wrote: > > Can you please point to the documentation. > > > > AFAIU there is just one documentation. Here is the link for it: > > https://www.postgresql.org/docs/current/view-pg-replication-slots.html
Thanks. Description of confirmed_flush_lsn is "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." The second sentence is misleading. AFAIU, it really should be "Data corresponding to the transactions committed before this LSN is not available anymore". WAL before restart_lsn is likely to be removed but WAL with LSN higher than restart_lsn is preserved. This correction makes more sense because of the third sentence. > > And.. lastly sorry for the delayed response. I was not well and > couldn't access email for quite some days. The poor dengue had almost > killed me :( Dengue had almost killed me also. Take care. -- Best Wishes, Ashutosh Bapat
