thank you . I changed the value to 1M and I started seeing the autovacuum being triggered. But I am getting the following message
ERROR: canceling autovacuum task, is it because the table are getting updated and the vacuum process in place and vacuum happens at a later point of time Regards On Wed, Mar 3, 2010 at 1:02 PM, Joao Ferreira gmail < joao.miguel.c.ferre...@gmail.com> wrote: > 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 > > > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
