Re: Block level parallel vacuum WIP - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Block level parallel vacuum WIP
Date
Msg-id 10219.1471955521@sss.pgh.pa.us
Whole thread Raw
In response to Re: Block level parallel vacuum WIP  (Claudio Freire <klaussfreire@gmail.com>)
Responses Re: Block level parallel vacuum WIP  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
List pgsql-hackers
Claudio Freire <klaussfreire@gmail.com> writes:
> Not only that, but from your description (I haven't read the patch,
> sorry), you'd be scanning the whole index multiple times (one per
> worker).

What about pointing each worker at a separate index?  Obviously the
degree of concurrency during index cleanup is then limited by the
number of indexes, but that doesn't seem like a fatal problem.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: distinct estimate of a hard-coded VALUES list
Next
From: Craig Ringer
Date:
Subject: Re: Logical decoding of sequence advances, part II