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

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.
Дата
Msg-id 20160302153500.GA422420@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.  (David Gould <daveg@sonic.net>)
Ответы Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.  (Joe Conway <mail@joeconway.com>)
Список pgsql-bugs
Дерево обсуждения 
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.

> + autovacuum contention patch: 5225 tables per minute

Great stuff.  I intend to look at this as a backpatchable bug fix during
this commitfest.

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

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

Предыдущее
От: David Gould
Дата:
Сообщение: Re: Prepared statements
Следующее
От: johann@visagie.za.net
Дата:
Сообщение: BUG #13996: json_to_record() returns non-NULL, malformed value for omitted key under some circumstances