Re: Database-wide VACUUM ANALYZE

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

 




On 6/21/07, Francisco Reyes <lists@xxxxxxxxxxxxxxxx> wrote:
Are you on FreeBSD by any chance?

I think the FreeBSD port by default installs a script that does a daily
vacuum.

Yes, FreeBSD.  Do you know what script that is?  And it does a db-wide VACUUM ANALYZE every day?!  That is certainly not necessary, and in fact, costly for us.
 
Hmmm... I wonder why this would just start now, three days ago.  Everything seemed to be normal for the last two weeks.
 
Steve

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

  Powered by Linux