Re: Auto VACUUM - Mailing list pgsql-general

On Wed, 2010-03-03 at 12:46 -0500, akp geek wrote:
> Hi All -
>
>           I need some help from you. this question is in follow up
> with my earlier questions. I turned the autovacuum and restarted the
> db and the settings I have as follows. It seems the autovacuum process
> has not been turned on. It's almost more than 3 hours I have restarted
> my DB with following setting.  I have ps -ef to see the proces list.
> Is there some thing I am doing wrong.
>
> Can you please help?

I'dd suggest leaving the "naptime" in the default (60 seconds)

Your value is very high... too high... I'dd say....

Use values around 60 seconds (never minutes)...

>
> Regards
>
> # - Query/Index Statistics Collector -
> #track_activities = on
> track_counts = on
> #track_functions = none                 # none, pl, all
> #track_activity_query_size = 1024
> #update_process_title = on
> #stats_temp_directory = 'pg_stat_tmp'
>
>
> #------------------------------------------------------------------------------
> # AUTOVACUUM PARAMETERS
> #------------------------------------------------------------------------------
>
> autovacuum = on                 # Enable autovacuum subprocess?  'on'
>                                         # requires track_counts to
> also be on.
> #log_autovacuum_min_duration = -1       # -1 disables, 0 logs all
> actions and
>                                         # their durations, > 0 logs
> only
>                                         # actions running at least
> this number
>                                         # of milliseconds.
> autovacuum_max_workers = 10             # max number of autovacuum
> subprocesses
> autovacuum_naptime = 180min             # time between autovacuum runs
> #autovacuum_vacuum_threshold = 50       # min number of row updates
> before
>                                         # vacuum
> #autovacuum_analyze_threshold = 50      # min number of row updates
> before
>                                         # analyze
> #autovacuum_vacuum_scale_factor = 0.2   # fraction of table size
> before vacuum
> #autovacuum_analyze_scale_factor = 0.1  # fraction of table size
> before analyze
> #autovacuum_freeze_max_age = 200000000  # maximum XID age before
> forced vacuum
>                                         # (change requires restart)
> #autovacuum_vacuum_cost_delay = 20ms    # default vacuum cost delay
> for
>                                         # autovacuum, in milliseconds;
>                                         # -1 means use
> vacuum_cost_delay
> #autovacuum_vacuum_cost_limit = -1      # default vacuum cost limit
> for
>                                         # autovacuum, -1 means use
>                                         # vacuum_cost_limit
>
>