Re: multixacts woes - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: multixacts woes
Date
Msg-id 554FA418.5070603@dunslane.net
Whole thread Raw
In response to Re: multixacts woes  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 05/10/2015 10:30 AM, Robert Haas wrote:


>>> 2. We have some logic that causes autovacuum to run in spite of
>>> autovacuum=off when wraparound threatens.  My commit
>>> 53bb309d2d5a9432d2602c93ed18e58bd2924e15 provided most of the
>>> anti-wraparound protections for multixact members that exist for
>>> multixact IDs and for regular XIDs, but this remains an outstanding
>>> issue.  I believe I know how to fix this, and will work up an
>>> appropriate patch based on some of Thomas's earlier work.
>> I believe autovacuum=off is fortunately uncommon, but certainly getting
>> this issue fixed is a good idea.
> Right.
>
>


I suspect it's quite a bit more common than many people imagine.

cheers

andrew



pgsql-hackers by date:

Previous
From: Noah Misch
Date:
Subject: Re: multixacts woes
Next
From: Tom Lane
Date:
Subject: Re: Custom/Foreign-Join-APIs (Re: [v9.5] Custom Plan API)