Re: pg_multixact issues

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: pg_multixact issues
Дата
Msg-id 20160210220553.GA365600@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: pg_multixact issues  (Thomas Munro <thomas.munro@enterprisedb.com>)
Ответы Re: pg_multixact issues  (Thomas Munro <thomas.munro@enterprisedb.com>)
Список 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 по дате отправления:

Предыдущее
От: Ivan Voras
Дата:
Сообщение: Re: Catalog bloat (again)
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: pg_multixact issues