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@gregsmith.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?
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD