Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 01B722E33E2 for ; Sun, 10 Feb 2008 19:48:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 53111-01-2 for ; Sun, 10 Feb 2008 19:48:50 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 542172E35CE for ; Sun, 10 Feb 2008 19:48:01 -0400 (AST) Received: from perhan.alvh.no-ip.org (200-126-75-43.bk5-dsl.surnet.cl [200.126.75.43]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m1ANmFJm030818 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Sun, 10 Feb 2008 15:48:18 -0800 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 0645F47BEB; Sun, 10 Feb 2008 20:47:57 -0300 (CLST) Date: Sun, 10 Feb 2008 20:47:56 -0300 From: Alvaro Herrera To: "Dean Gibson (DB Administrator)" Cc: pgsql-admin@postgresql.org Subject: Re: Getting "ERROR: canceling autovacuum task" Message-ID: <20080210234756.GA7093@alvh.no-ip.org> References: <47AF34AE.3070806@ultimeth.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <47AF34AE.3070806@ultimeth.com> User-Agent: Mutt/1.5.17+20080114 (2008-01-14) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Sun, 10 Feb 2008 15:48:19 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/127 X-Sequence-Number: 28201 Dean Gibson (DB Administrator) wrote: > I'm getting this loading some large (1 million row) tables. Is this > anything to be concerned about? No, it's normal. It means the autovacuum task was cancelled in order to avoid blocking your regular Postgres sessions. If it's only during table loading, there's no problem -- the table will be processed later eventually. If it happens all the time, I would advise setting a cron job to carry out the vacuum task. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.