Postgres Pro
Downloads
Home   >   mailing lists

Multiple table scans to analyze multiple indexes - Mailing list pgsql-general

From Thom Brown
Subject Multiple table scans to analyze multiple indexes
Date
Msg-id AANLkTikzog2iiW-crC_YQT2Oj3ycUPnt-NovSCLRfnjP@mail.gmail.com
Whole thread Raw
Responses Re: Multiple table scans to analyze multiple indexes  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general
Tree view 
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 Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: Analyze tool?
Next
From: ioguix
Date:
Subject: Re: Analyze tool?