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

From Jeff Janes
Subject Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.
Date
Msg-id CAMkU=1wAhEWgD9bdFk6k0M7=c7YifJb56_J51juva8rKrtQaDQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Fri, Oct 30, 2015 at 8:53 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Alvaro Herrera <alvherre@2ndquadrant.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

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.
Next
From: "Shulgin, Oleksandr"
Date:
Subject: Re: BUG #13747: Like clause ignoring raws with null value