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 20151030151711.GF5726@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.
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 cost delays are all 0. We care about bloat, not bandwidth.
>
> Anyway, they are not actually vacuuming. They are waiting on the
> VacuumScheduleLock. And requesting freshs snapshots from the
> stats_collector.

Oh, I see.  Interesting.  Proposals welcome.  I especially dislike the
("very_expensive") pgstat check.

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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #13749: PostgreSQL cann't compress random data?
Next
From: Tom Lane
Date:
Subject: Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.