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

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, David Gould <daveg(at)sonic(dot)net>, Pg Bugs <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 16:16:52
Message-ID: CAMkU=1wAhEWgD9bdFk6k0M7=c7YifJb56_J51juva8rKrtQaDQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Oct 30, 2015 at 8:53 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> writes:
>> Of course, if we could avoid the pgstat check completely that would be
>> even better. The amount of pgstat traffic that causes is ridiculous.
>
> Good point ... shouldn't we have already checked the stats before ever
> deciding to try to claim the table?

If forces another pg_stat just before it claims the table, in case the
table had just finished being vacuumed.

Cheers,

Jeff

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Shulgin, Oleksandr 2015-10-30 16:50:12 Re: BUG #13747: Like clause ignoring raws with null value
Previous Message Alvaro Herrera 2015-10-30 16:11:50 Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.