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