Re: hot_standby_feedback implementation - Mailing list pgsql-general

From Peter Geoghegan
Subject Re: hot_standby_feedback implementation
Date
Msg-id CAH2-Wzkjz8kKPpje5oX29Of=vUkHZNi2nXsWmsP586pndbNzqA@mail.gmail.com
Whole thread Raw
In response to hot_standby_feedback implementation  (Christophe Pettus <xof@thebuild.com>)
Responses Re: hot_standby_feedback implementation  (Christophe Pettus <xof@thebuild.com>)
List pgsql-general
On Tue, Jun 15, 2021 at 5:24 PM Christophe Pettus <xof@thebuild.com> wrote:
> When a replica sends a hot_standby_feedback message to the primary, does that create an entry in the primary's lock
table,or is it flagged to autovacuum some other way?
 

It pretty much works by making the WAL sender process on the primary
look like it holds a snapshot that's as old as the oldest snapshot on
the replica.

A replica can block VACUUM on the primary *directly* by holding a
table-level lock, though in practice only when somebody on the replica
acquires an AccessExclusiveLock -- which is presumably rare in
practice.

-- 
Peter Geoghegan



pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: hot_standby_feedback implementation
Next
From: Christophe Pettus
Date:
Subject: Re: hot_standby_feedback implementation