Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 86CEB9FA150 for ; Tue, 4 Sep 2007 15:52:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 09247-05 for ; Tue, 4 Sep 2007 15:52:34 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web31804.mail.mud.yahoo.com (web31804.mail.mud.yahoo.com [68.142.207.67]) by postgresql.org (Postfix) with SMTP id 647AF9F9CC5 for ; Tue, 4 Sep 2007 15:52:33 -0300 (ADT) Received: (qmail 44348 invoked by uid 60001); 4 Sep 2007 18:52:31 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=CIwZYpIxwvqifb4EJSH6p+3G1MEGb04hhYOpCYkmzMlQDQHf0BwEhSP2qM2ooxrpyRFvcyjpX4wIk3yQDGDLKESh2M/eNThvFsAs39rdWo0Evd0aNd90CBB1OuPfMpF6z9oq7NaWVViBwsdE6MRrtC3kpYcWblc1L8L387+nV/s=; X-YMail-OSG: 6kQy5S0VM1nEPtLSeOyfda_FwCDBA7RkiE4WyAjFjqXuB0Xi1cLWyJ3Fl9E_zHzAyN9TkXEE5wGPPegtPiycZDp7a24pcyy8.LicmThp4aKIAG9fs9iQp0nSLQ-- Received: from [12.180.237.138] by web31804.mail.mud.yahoo.com via HTTP; Tue, 04 Sep 2007 11:52:31 PDT Date: Tue, 4 Sep 2007 11:52:31 -0700 (PDT) From: Richard Broersma Jr Subject: Re: Vacum Analyze problem To: rafael@akyasociados.com.ar, kevin@kevinkempterllc.com Cc: pgsql-performance@postgresql.org In-Reply-To: <1620.192.168.1.229.1188931580.squirrel@webmail.akyasociados.com.ar> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <223348.43586.qm@web31804.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/26 X-Sequence-Number: 26571 --- rafael@akyasociados.com.ar wrote: > Thank you all for the information. I'll get to work on it and see what > happends. > Thanks again > > Rafael I'll chime in with one last thought about excellent resources on Vacuum: http://www.postgresql.org/docs/8.2/static/sql-vacuum.html http://www.postgresql.org/docs/8.2/static/sql-analyze.html http://www.postgresql.org/docs/8.2/static/routine-vacuuming.html Regards, Richard Broersma Jr.