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. > +1 We could eventually need some effective way of parallelizing vacuum of single index. But pointing each worker at separate index seems to be fair enough for majority of cases. ------ Alexander Korotkov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company