Search Postgresql Archives

Re: automatic REINDEX-ing

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

 



> Because VACUUM FULL needs to move stuff around in the table which means it
> need to mess around with the indexes (adding new entries). Ordinary
> VACUUM only needs to delete stuff so doesn't cause anywhere near as
> many problems.

so.... in  the event that I really end up running VACUUM FULL once in a
while, it seems to me it is a good idea to run REINDEX.

Is this correct ?

thx
joao


> 
> Have a nice day,




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux