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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
