| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Cc: | David Gould <daveg(at)sonic(dot)net>, 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:40:27 |
| Message-ID: | 13594.1446219627@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> writes:
> David Gould wrote:
>> 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.
Couldn't we simply move that out of the locked stanza? That is, if no
other worker is working on the table, claim it, and release the lock
immediately. Then do the "very expensive" check. If that fails, we
have to re-take the lock to un-claim the table, but that sounds OK.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2015-10-30 15:49:37 | Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower. |
| Previous Message | Alvaro Herrera | 2015-10-30 15:17:11 | Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower. |