Re: serious problems with vacuuming databases

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux