Re: [GENERAL] Multiple table scans to analyze multiple indexes

2010-10-20 Thread Bruce Momjian
Thom Brown wrote: > Hi all, > > I might not be understanding this correctly, but does Postgres, when > VACUUM ANALYZE-ing a table, perform separate scans for each index? > And if so, is this necessary? Can't it update indexes parallel? This > would be particularly useful when rebuilding all inde

[GENERAL] Multiple table scans to analyze multiple indexes

2010-10-01 Thread Thom Brown
Hi all, I might not be understanding this correctly, but does Postgres, when VACUUM ANALYZE-ing a table, perform separate scans for each index? And if so, is this necessary? Can't it update indexes parallel? This would be particularly useful when rebuilding all indexes on a table. Thanks Thom