Hi, On 28 February 2012 11:53, Jameison Martin <[email protected]> wrote: > I'm seeing "GMTERROR: canceling autovacuum task" lines in my logs.
That's *should* be fine. autovacuum daemon is smart enough to cancel it self when other query needs access to the table. The affected table will be vacuumed/analysed later. You should monitor pg_stat_user_tables view to see how often is the table vacuumed/analysed. -- Ondrej Ivanic ([email protected]) -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
