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 93EBE9DC821 for ; Sun, 19 Mar 2006 08:27:29 -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 09045-02 for ; Sun, 19 Mar 2006 08:27:32 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.199]) by postgresql.org (Postfix) with ESMTP id 1E8459DC812 for ; Sun, 19 Mar 2006 08:27:26 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 14so912810nzn for ; Sun, 19 Mar 2006 04:27:30 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=TA9txlokYM3AopDIZmay+corNAK1nLb7cfPFsNXNqpT1GnZin6xMFo1vbOBMcALEQnLav7hGALpxe/8LTDNLYizZ7EV6ciVT9BUxXgMGs5CgHXi/sGYSL0MzVP6gCfU27GTiw4he99iJbZwk0DB3li6iTfS73hpkouXZJyao/4I= Received: by 10.35.107.20 with SMTP id j20mr801665pym; Sun, 19 Mar 2006 04:27:30 -0800 (PST) Received: by 10.35.37.10 with HTTP; Sun, 19 Mar 2006 04:27:29 -0800 (PST) Message-ID: <92d3a4950603190427m47f5fad6k@mail.gmail.com> Date: Sun, 19 Mar 2006 13:27:29 +0100 From: Antoine To: "Andreas Pflug" Subject: Re: n00b autovacuum question Cc: pgsql-performance@postgresql.org In-Reply-To: <441C4758.9000205@pse-consulting.de> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <92d3a4950603180401p7deb391cp@mail.gmail.com> <441C4758.9000205@pse-consulting.de> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.184 required=5 tests=[AWL=0.184] X-Spam-Score: 0.184 X-Spam-Level: X-Archive-Number: 200603/314 X-Sequence-Number: 17751 On 18/03/06, Andreas Pflug wrote: > 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. > > pgAdmin notices a discrepancy between real rowcount and estimated > rowcount and thus suggests to run vacuum/analyze; it won't examine > autovacuum rules so it might warn although autovac is running ok. > > If you're sure autovacuum is running fine, just dismiss the message. I guess that is my problem - I a not sure it is running fine. The process is definitely running but I am getting lots of complaints about performance. This probably has lots to do with crap code and not much to do with the database but I am still searching the maintenance avenue... We have a massive project coming up and I want to go for Postgres (the boss wants Oracle). If I can't get my stuff together I am not sure my arguments will stick... problem is I don't really have the time to experiment properly. Cheers Antoine -- This is where I should put some witty comment.