On Sun, May 31, 2009 at 10:26 PM, S Arvind <arvindwill(at)gmail(dot)com> 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?
Just write a SQL script with the appropriate commands and run it using
psql from cron. Set up your .pgpass and/or pg_hba.conf as
appropriate.
-Dave