Re: Auto vacuum

I'm not sure if we've done a reload. I'm in an academic environment
and our department is in a state of flux right now. I'm in the
process of trying to get up to speed on postgreSQL as fast as I can.
Here is the result set from that query.

select * from pg_settings where name = 'autovacuum';
name | setting | unit | category |
short_desc |
extra_desc | context | vartype | source | min_val | max_val
------------+---------+------+------------
+-----------------------------------+-
-----------+---------+---------+--------------------+---------+---------
autovacuum | on | | Autovacuum | Starts the autovacuum
subprocess. |
| sighup | bool | configuration file | |
(1 row)

Thank you,

Carol

On Apr 19, 2007, at 4:59 PM, Robert Treat wrote:

> 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