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

From Tom Lane
Subject Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.
Date
Msg-id 15347.1446223903@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.  (Jeff Janes <jeff.janes@gmail.com>)
Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.  (David Gould <daveg@sonic.net>)
List pgsql-bugs
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> Tom Lane wrote:
>> Good point ... shouldn't we have already checked the stats before ever
>> deciding to try to claim the table?

> The second check is there to allow for some other worker (or manual
> vacuum) having vacuumed it after we first checked, but which had
> finished before we check the array of current jobs.

I wonder whether that check costs more than it saves.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Shulgin, Oleksandr"
Date:
Subject: Re: BUG #13747: Like clause ignoring raws with null value
Next
From: Kevin Grittner
Date:
Subject: Re: BUG #13667: SSI violation...