Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.
Дата
Msg-id 56D71103.7060500@joeconway.com
обсуждение исходный текст
Ответ на Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-bugs
Дерево обсуждения 
On 03/02/2016 07:35 AM, Alvaro Herrera wrote:
> David Gould wrote:
>> The following is a summary of strace output for the autovacuum workers
>> and the stats collector while the 40k table test is running. The counts =
and
>> times are the cost per table.
>>
>> postgresql 9.5:   85 tables per minute.
>=20
>> + autovacuum contention patch: 5225 tables per minute
>=20
> Great stuff.  I intend to look at this as a backpatchable bug fix during
> this commitfest.

+1!


--=20
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development

В списке pgsql-bugs по дате отправления:

Предыдущее
От: johann@visagie.za.net
Дата:
Сообщение: BUG #13996: json_to_record() returns non-NULL, malformed value for omitted key under some circumstances
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: BUG #13770: Extending recovery_min_apply_delay on Standby causes it to be unavailable for a while