X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id CD0D09DCDF7 for ; Sat, 18 Mar 2006 08:01:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 06926-03 for ; Sat, 18 Mar 2006 08:01:26 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.203]) by postgresql.org (Postfix) with ESMTP id C872B9DCDD4 for ; Sat, 18 Mar 2006 08:01:21 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i21so750037wra for ; Sat, 18 Mar 2006 04:01:25 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=nZTK8+EY/b17POxT7bluzFd4yrHcAYMXHurFqyJjEhR24FgbtjlJgY05wgNS4Vf8Izte8wq7LJc8htRvpFZBcd0NXTO6Ud4Z/cwSH3kap4gmCUt+N+dJuYlYK+b49NaOESMRHSzMsMtjt7N9olfGtkDl6gKUuCu5/I+K+jDz8yM= Received: by 10.35.34.20 with SMTP id m20mr1927556pyj; Sat, 18 Mar 2006 04:01:24 -0800 (PST) Received: by 10.35.37.10 with HTTP; Sat, 18 Mar 2006 04:01:24 -0800 (PST) Message-ID: <92d3a4950603180401p7deb391cp@mail.gmail.com> Date: Sat, 18 Mar 2006 13:01:24 +0100 From: Antoine To: pgsql-performance@postgresql.org Subject: n00b autovacuum question MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.2 required=5 tests=[AWL=0.200] X-Spam-Score: 0.2 X-Spam-Level: X-Archive-Number: 200603/304 X-Sequence-Number: 17741 Hi, I have enabled the autovacuum daemon, but occasionally still get a message telling me I need to run vacuum when I access a table in pgadmin. Is this normal? Should I use scripts instead of the daemon? Would posting config options make this a much more sensible question? Cheers Antoine -- This is where I should put some witty comment.