My RAM size is 8GB. I have set the maintenance_work_mem = 500MB this morning.
ERROR: canceling autovacuum task with table name Thanks for the help Regards On Wed, Mar 3, 2010 at 4:31 PM, Igor Neyman <iney...@perceptron.com> wrote: > 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 > > > > > > > > >
