On Tue, Aug 23, 2016 at 3:32 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Claudio Freire <klaussfre...@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.
We could eventually need some effective way of parallelizing vacuum of
But pointing each worker at separate index seems to be fair enough for
majority of cases.
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company