Postgres Pro
Downloads
Home   >   mailing lists

Re: Movement of restart_lsn position movement of logical replication slots is very slow - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: Movement of restart_lsn position movement of logical replication slots is very slow
Date
Msg-id CAA4eK1KMvTD=u3XRb88-=XuzvcYWkkmwj_vQ1C+LkpRxGGnFkg@mail.gmail.com
Whole thread Raw
In response to Re: Movement of restart_lsn position movement of logical replication slots is very slow  (Jammie <shailesh.jamloki@gmail.com>)
Responses Re: Movement of restart_lsn position movement of logical replication slots is very slow
List pgsql-hackers
Tree view 
On Thu, Dec 24, 2020 at 7:30 PM Jammie <shailesh.jamloki@gmail.com> wrote:
>
> Sorry dont have the debug setup handy. However the sql commands now works though to move the restart_lsn of the slots
instandlone code from psql.
 
>
>  A few followup questions.
>
> What is catalog_xmin in the pg_replication_slots ? and how is it playing role in moving the restart_lsn of the slot.
>
> I am just checking possibility that if a special transaction can cause private slot to stale ?
>

Yeah, it is possible if there is some old transaction is active in the
system. The restart_lsn is lsn required by the oldesttxn. But it is
strange that it affects only one of the slots.

-- 
With Regards,
Amit Kapila.

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: postgres_fdw - cached connection leaks if the associated user mapping/foreign server is dropped
Next
From: Bharath Rupireddy
Date:
Subject: Re: postgres_fdw - cached connection leaks if the associated user mapping/foreign server is dropped