Re: Auto VACUUM - Mailing list pgsql-general

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:akpgeek@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.ferreira@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
>
>
>
>