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

Re: Auto vacuum

From: Robert Treat <robert(at)omniti(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: Carol Walter <walterc(at)indiana(dot)edu>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Auto vacuum
Date: 2007-04-19 20:59:42
Message-ID: 200704191659.44378.robert@omniti.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Thursday 19 April 2007 13:54, Carol Walter wrote:
> I certainly appreciate the help you've given.  Here's what the code
> in this part of postgresql.conf file says.
>
> autovacuum = on
>
> autovacuum_naptime = 30         # time between autovacuum runs, in secs
> autovacuum_vacuum_threshold = 500       # min # of tuple updates before
>                                          # vacuum
> autovacuum_analyze_threshold = 250      # min # of tuple updates before
>                                          # analyze
> autovacuum_vacuum_scale_factor = 0.2    # fraction of rel size before
>                                          # vacuum
> autovacuum_analyze_scale_factor = 0.1   # fraction of rel size before
>                                          # analyze
> autovacuum_vacuum_cost_delay = -1       # default vacuum cost delay for
>                                          # autovac, -1 means use
>                                          # vacuum_cost_delay
> #autovacuum_vacuum_cost_limit = -1      # default vacuum cost limit for
>                                          # autovac, -1 means use
>                                          # vacuum_cost_limit
>

Do you know if you have done a reload of the config files since these were 
changed? Try doing a select * from pg_settings where name ~ 'autovacuum' to 
see what your db is currently using.

-- 
Robert Treat
Database Architect
http://www.omniti.com

In response to

Responses

pgsql-admin by date

Next:From: Carol WalterDate: 2007-04-19 21:03:34
Subject: Re: Auto vacuum
Previous:From: Alexander B.Date: 2007-04-19 20:28:30
Subject: Get information from SMNP

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