On Sun, May 31, 2009 at 10:26 PM, S Arvind <arvindwill@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
