Re: GiST VACUUM - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: GiST VACUUM
Date
Msg-id 835A15A5-F1B4-4446-A711-BF48357EB602@yandex-team.ru
Whole thread Raw
In response to Re: GiST VACUUM  (Heikki Linnakangas <hlinnaka@iki.fi>)
Responses Re: GiST VACUUM
List pgsql-hackers

> 22 марта 2019 г., в 17:03, Heikki Linnakangas <hlinnaka@iki.fi> написал(а):
>

I was working on new version of gist check in amcheck and understand one more thing:

/* Can this page be recycled yet? */
bool
gistPageRecyclable(Page page)
{
    return PageIsNew(page) ||
        (GistPageIsDeleted(page) &&
         TransactionIdPrecedes(GistPageGetDeleteXid(page), RecentGlobalXmin));
}

Here RecentGlobalXmin can wraparound and page will become unrecyclable for half of xid cycle. Can we prevent it by
resettingPageDeleteXid to InvalidTransactionId before doing RecordFreeIndexPage()? 
(Seems like same applies to GIN...)

Best regards, Andrey Borodin.

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: jsonpath
Next
From: Tattsu Yama
Date:
Subject: Re: [HACKERS] CLUSTER command progress monitor