On Mon, Jun 1, 2009 at 8:35 PM, Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> wrote: > 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. But before you try that, try just using the default settings and see if you actually have a problem. ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
