Re: Vacuuming technique doubt

Hi Smith,
The reason why we need it manually is , we don't need any performance drop
in our production hours. So we figured out the most less usage working time,
most freq used tables and want to perform that on daily . so in weekends we
can vaccum and reindex entire db.. Is the model is not more efficient Smith?

-Arvind S

*
"Many of lifes failure are people who did not realize how close they were to
success when they gave up."
-Thomas Edison
*

On Mon, Jun 1, 2009 at 9:04 PM, Greg Smith <gsmith(at)gregsmith(dot)com> wrote:

> On Mon, 1 Jun 2009, S Arvind wrote:
>
> Having a doubt, we want to vacuum and reindex some 50 most used tables
>> daily on specific time. Is it best to have a function in
>> postgres and call it in cron or is there any other good way to do the two
>> process for specified tables at specified time?
>>
>
> If you haven't been using VACUUM properly, it's possible to get into a
> position where you need to REINDEX your tables and go through the sort of
> giant cleanup step you describe. If you think you need to do that daily,
> though, you probably should take a look at tuning autovacuum rather than
> trying to fix the problem manually all the time.
>
> --
> * Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
>