Skip site navigation (1) Skip section navigation (2)

Re: auto vacuum for opentaps

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Ernesto Eduardo Medina Núñez <eemnpg(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: auto vacuum for opentaps
Date: 2008-07-21 16:38:52
Message-ID: 20080721163852.GI5842@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-admin
Ernesto Eduardo Medina Núñez escribió:

Hi,

> *autovacuum = on   *              # enable autovacuum subprocess?
> #autovacuum_naptime = 60                # time between autovacuum runs, in
> secs
> #autovacuum_vacuum_threshold = 1000     # min # of tuple updates before
>                                         # vacuum
> #autovacuum_analyze_threshold = 500     # min # of tuple updates before
> analyze
> #autovacuum_vacuum_scale_factor = 0.4   # fraction of rel size before vacuum
> #autovacuum_analyze_scale_factor = 0.2  # fraction of rel size before
> analyze

The thresholds and scale_factors that came with this release were too
conservative.  I suggest reducing them to 50 and 0.1, respectively.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

pgsql-admin by date

Next:From: Rajesh Kumar MallahDate: 2008-07-22 12:17:42
Subject: conditional logging based on client
Previous:From: Scott MarloweDate: 2008-07-21 16:31:42
Subject: Re: auto vacuum for opentaps

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group