Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] make async slave to wait for lsn to be replayed - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] make async slave to wait for lsn to be replayed
Date
Msg-id 32218.1586550579@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] make async slave to wait for lsn to be replayed  (Andres Freund <andres@anarazel.de>)
Responses Re: [HACKERS] make async slave to wait for lsn to be replayed  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Tree view 
Andres Freund <andres@anarazel.de> writes:
> I don't think a function is a good idea - it'll cause a snapshot to be
> held while waiting. Which in turn will cause hot_standby_feedback to not
> be able to report an increased xmin up. And it will possibly hit
> snapshot recovery conflicts.

Good point, but we could address that by making it a procedure no?

            regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump issue with renamed system schemas
Next
From: David Steele
Date:
Subject: Re: pg_basebackup, manifests and backends older than ~12