Re: multixacts woes

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