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

From: David Gould <daveg(at)sonic(dot)net>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
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-31 04:23:17
Message-ID: 20151030212317.7f1bddfa@engels
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, 30 Oct 2015 12:17:11 -0300
Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> wrote:

> 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.

I have an effective patch for this issue that I think is small enough to be
backpatched. I'm cleaning it up a bit and will send it this weekend.

-dg

--
David Gould 510 282 0869 daveg(at)sonic(dot)net
If simplicity worked, the world would be overrun with insects.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Janes 2015-10-31 04:49:00 Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.
Previous Message stefanov.sm 2015-10-30 20:14:00 BUG #13751: PGAdmin III function text error