Multiple table scans to analyze multiple indexes

From: Thom Brown <thom(at)linux(dot)com>
To: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Multiple table scans to analyze multiple indexes
Date: 2010-10-01 10:49:03
Message-ID: AANLkTikzog2iiW-crC_YQT2Oj3ycUPnt-NovSCLRfnjP@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank Church 2010-10-01 10:51:34 How many databases can PostgreSQL open at a time?
Previous Message Thom Brown 2010-10-01 10:30:59 Re: Analyze tool?