Page 1 of 1

Database Housekeeping automation

PostPosted: Fri May 03, 2013 7:30 am
by Zatoichi
I would like to have dialog where I can select more than one housekeeping tasks to execute.

For example i check Cluster, Rebuild Cache and Vacuum & Analyze, click OK and go outside to drink beer. :)

Re: Database Housekeeping automation

PostPosted: Fri May 03, 2013 8:00 am
by kraada
These do not need to be done regularly, and Vacuum/Analyze are already included in the other options so you wouldn't need to do that one separately regardless.

Re: Database Housekeeping automation

PostPosted: Fri May 03, 2013 9:08 am
by Zatoichi
I found Housekeeping very confusing. I still don't know when to do it and what to do. Now when I notice that HUD is slower I run all tasks but I know this is not necessary.

Is it possible to PT keep track of needed task and warn user? Something like "It past x days and y hands since you last time _____ . It is time to do it. Press OK." :roll:

Re: Database Housekeeping automation

PostPosted: Fri May 03, 2013 9:23 am
by kraada
These do not need to be done regularly. There is no harm from it, but little to no benefit, either.