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