Postgres Pro
Downloads
Home   >   mailing lists

Re: Database-wide VACUUM ANALYZE - Mailing list pgsql-performance

From Steven Flatt
Subject Re: Database-wide VACUUM ANALYZE
Date
Msg-id 357fa7590706211236y2856ed96q5394b9302b9a528f@mail.gmail.com
Whole thread Raw
In response to Re: Database-wide VACUUM ANALYZE  (Francisco Reyes <lists@stringsutils.com>)
Responses Re: Database-wide VACUUM ANALYZE
Re: Database-wide VACUUM ANALYZE
List pgsql-performance
Tree view

On 6/21/07, Francisco Reyes <lists@stringsutils.com> 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

pgsql-performance by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: Database-wide VACUUM ANALYZE
Next
From: Larry Rosenman
Date:
Subject: Re: Database-wide VACUUM ANALYZE