Horton

Re: gist microvacuum doesn't appear to care about hot standby?

Andres Freund <andres@anarazel.de>

View thread View on postgr.es
From: Andres Freund <andres@anarazel.de>
To: Alexander Korotkov <a.korotkov@postgrespro.ru>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>, Teodor Sigaev <teodor@sigaev.ru>, Anastasia Lubennikova <a.lubennikova@postgrespro.ru>
Date: 2019-04-06T05:02:43Z
Lists: pgsql-hackers

Attachments

Hi,

On 2018-12-21 02:40:18 +0300, Alexander Korotkov wrote:
> On Thu, Dec 20, 2018 at 1:41 AM Alexander Korotkov
> <a.korotkov@postgrespro.ru> wrote:
> > Please, find attached two patches I'm going to commit: for master and
> > for backpatching.
> 
> So, pushed.

I noticed that I didn't adapt this in

commit 558a9165e081d1936573e5a7d576f5febd7fb55a
Author: Andres Freund <andres@anarazel.de>
Date:   2019-03-26 14:41:46 -0700

    Compute XID horizon for page level index vacuum on primary.


Attached you thus can find the conversion of gist to the new logic for
computing the horizon. Any comments?

Greetings,

Andres Freund

Commits

  1. Convert gist to compute page level xid horizon on primary.

  2. Compute XID horizon for page level index vacuum on primary.

  3. Check for conflicting queries during replay of gistvacuumpage()

  4. Microvacuum for GIST