Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5BA376501C2 for ; Mon, 21 Jul 2008 13:32:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 70633-05 for ; Mon, 21 Jul 2008 13:31:44 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.182]) by postgresql.org (Postfix) with ESMTP id 8E53765018B for ; Mon, 21 Jul 2008 13:31:44 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d37so845080pye.29 for ; Mon, 21 Jul 2008 09:31:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=LLbCJ9pkxanKv6xRmuLM8I7/R4LjjgFo3Bm+bEDYqfY=; b=oAn6e3xAoKZLkdVKGFvnxUnCT39EerQkmn5ujBxuSVFebPHd78NB5scylZ7FpWBLUK B0mVtPw5ixZAq7WHwfxSuVQ7/W1w3cDquOf/hU57/a17hF1HF83NCiiw+9WlhlWpAb9/ 3Lp1W29jHA6jcJM6PwzLE3Fd7Szw2K0CJsQiI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=n02t6aDjsWEZj8EjrpAJrrpBsxHVSbkoaXIFdUmwjTI/ii8pDRwZZxsG6rfXwh0daR Ru1vckClnuDk3yvT2NQfaGhEo3n1xZ1tY0nRTOP7/3chgXxUXV0ibz73WFgsh5oCqpTG Eqo6h/yO7layjk4Nfhdl65FnSoLOUzZdya6JM= Received: by 10.114.210.2 with SMTP id i2mr2883959wag.18.1216657902736; Mon, 21 Jul 2008 09:31:42 -0700 (PDT) Received: by 10.114.130.17 with HTTP; Mon, 21 Jul 2008 09:31:42 -0700 (PDT) Message-ID: Date: Mon, 21 Jul 2008 10:31:42 -0600 From: "Scott Marlowe" To: "=?ISO-8859-1?Q?Ernesto_Eduardo_Medina_N=FA=F1ez?=" Subject: Re: auto vacuum for opentaps Cc: pgsql-admin@postgresql.org In-Reply-To: <18cc0be90807210841l637556ffl7a239a10bc45c285@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <18cc0be90807210841l637556ffl7a239a10bc45c285@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200807/180 X-Sequence-Number: 29790 On Mon, Jul 21, 2008 at 9:41 AM, Ernesto Eduardo Medina N=FA=F1ez wrote: > Hi I installed the open source ERP Opentaps which have 802 tables and usi= ng > PostgreSQL as backend, and also filled the tables with demo data. > > When I browse the tables using PgAdmin3 I get messages saying that: > The estimated row count on the table "some_table" deviates significantly > from the actual row count. You should run vacuum analyze. > > So I do it again and again with each table that throws me the message unt= il > I get tired, then I went to the database's root and click on maintenance, > vacuum analyze. > Then a long process begin, after that I continue browsing the tables but = I'm > still getting the messages, so I suppose that I'm not doing the vacuum > correctly. What is your default stats target set to? Try increasing it to 50 or 100 for this db and see if the message you're seeing goes away.