S Arvind <arvindwill@xxxxxxxxx> 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 entire db.. By the time you get to your mass reindex the bloat will be harming your performance much more than the autovacuum needs to do. Check the documentation here: http://www.postgresql.org/docs/8.3/interactive/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-VACUUM-COST I hope this helps. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
