Hi,
On 28 February 2012 11:53, Jameison Martin <jameisonb(at)yahoo(dot)com> 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
(ondrej(dot)ivanic(at)gmail(dot)com)