Re: pg_multixact issues - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: pg_multixact issues
Date
Msg-id 20160210220553.GA365600@alvherre.pgsql
Whole thread Raw
In response to Re: pg_multixact issues  (Thomas Munro <thomas.munro@enterprisedb.com>)
Responses Re: pg_multixact issues  (Thomas Munro <thomas.munro@enterprisedb.com>)
List pgsql-general
Thomas Munro wrote:

> 4.  You could look into whether all those multixacts with many member
> are really expected.  (Large numbers of concurrent FK checks or
> explicit share locks on the same rows perhaps?  A good proportion of
> this happened on one day this week I see.)

I think maybe this patch
https://www.postgresql.org/message-id/20150620043650.GX133018%40postgresql.org
should help with this.  I expect to come back to this and get it pushed
to 9.3 and 9.4 sometime ...

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-general by date:

Previous
From: Ivan Voras
Date:
Subject: Re: Catalog bloat (again)
Next
From: Thomas Munro
Date:
Subject: Re: pg_multixact issues