Tomas Vondra wrote:
> > Huh, I didn't suggest to dump/reload. I suggested CLUSTER. You need to
> > apply it only to tables where you have lots of dead tuples, which IIRC
> > are A, C and D.
>
> Sorry, I should read more carefully. Will clustering a table according
> to one index solve problems with all the indexes on the table (if the
> table has for example two indexes?).
Yes, it will rebuild all indexes.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.