Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower. - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.
Date
Msg-id 20160302153500.GA422420@alvherre.pgsql
Whole thread Raw
In response to Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.  (David Gould <daveg@sonic.net>)
Responses Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.
List pgsql-bugs
Tree view 
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 by date:

Previous
From: David Gould
Date:
Subject: Re: Prepared statements
Next
From: johann@visagie.za.net
Date:
Subject: BUG #13996: json_to_record() returns non-NULL, malformed value for omitted key under some circumstances