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

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: David Gould <daveg(at)sonic(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.
Date: 2015-10-30 15:17:11
Message-ID: 20151030151711.GF5726@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2015-10-30 15:40:27 Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.
Previous Message Tom Lane 2015-10-30 15:12:57 Re: BUG #13749: PostgreSQL cann't compress random data?