What's the complete error message? Vacuum is using maintenance_work_mem. What is your setting maintenance_work_mem compared to your RAM size.
Igor Neyman > -----Original Message----- > From: akp geek [mailto:akpg...@gmail.com] > Sent: Wednesday, March 03, 2010 1:10 PM > To: Joao Ferreira gmail > Cc: pgsql-general > Subject: Re: Auto VACUUM > > 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 > > > > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
