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 5ECA99DCC36 for ; Sat, 18 Mar 2006 11:54:08 -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 58494-03 for ; Sat, 18 Mar 2006 11:54:13 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from outbound.mailhop.org (outbound.mailhop.org [63.208.196.171]) by postgresql.org (Postfix) with ESMTP id 68B009DCC34 for ; Sat, 18 Mar 2006 11:54:06 -0400 (AST) Received: from ool-45745d9b.dyn.optonline.net ([69.116.93.155] helo=[192.168.4.92]) by outbound.mailhop.org with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.51) id 1FKdkp-0000yy-1K; Sat, 18 Mar 2006 10:54:11 -0500 X-Mail-Handler: MailHop Outbound by DynDNS X-Originating-IP: 69.116.93.155 X-Report-Abuse-To: abuse@dyndns.com (see http://www.mailhop.org/outbound/abuse.html for abuse reporting information) X-MHO-User: zeut Message-ID: <441C2D26.20309@zeut.net> Date: Sat, 18 Mar 2006 10:54:14 -0500 From: "Matthew T. O'Connor" User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: Antoine CC: pgsql-performance@postgresql.org Subject: Re: n00b autovacuum question References: <92d3a4950603180401p7deb391cp@mail.gmail.com> In-Reply-To: <92d3a4950603180401p7deb391cp@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.131 required=5 tests=[AWL=0.131] X-Spam-Score: 0.131 X-Spam-Level: X-Archive-Number: 200603/307 X-Sequence-Number: 17744 More detail please. It sounds like you running 8.1 and talking about the integrated autovacuum is that correct? Also, what is the message specifically from pgadmin? Matt Antoine wrote: > 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. > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq >