On Sun, May 31, 2009 at 10:26 PM, S Arvind arvindw...@gmail.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
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
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
S Arvind arvindw...@gmail.com wrote:
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
On Mon, Jun 1, 2009 at 8:35 PM, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
S Arvind arvindw...@gmail.com wrote:
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
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?
-Arvind S
*
**Many of lifes failure are people