Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuum cancels autovacuum error message confusing? - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Vacuum cancels autovacuum error message confusing?
Date
Msg-id 20100420205741.GD3229@alvh.no-ip.org
Whole thread Raw
In response to Vacuum cancels autovacuum error message confusing?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Vacuum cancels autovacuum error message confusing?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: BETA
Next
From: Tom Lane
Date:
Subject: Re: Thoughts on pg_hba.conf rejection