Re: Vacuum cancels autovacuum error message confusing?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Vacuum cancels autovacuum error message confusing?
Date: 2010-04-20 20:57:41
Message-ID: 20100420205741.GD3229@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Josh Berkus wrote:

> vacuum...ERROR: canceling autovacuum task
> CONTEXT: automatic analyze of table "bench.public.pgbench_accounts"
> ERROR: canceling autovacuum task
> CONTEXT: automatic analyze of table "bench.public.pgbench_accounts"
> done.
>
> What happened above is that the build of the new pgbench database
> triggered an autovacuum, and then pgbench called a manual vacuum,
> cancelling the autovacuum.

Isn't this just because you ran the postmaster in the same terminal as
pgbench?

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-04-20 21:02:22 Re: Thoughts on pg_hba.conf rejection
Previous Message Robert Haas 2010-04-20 20:40:30 Re: BETA