Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7294C9FB7DE for ; Thu, 21 Jun 2007 15:58:43 -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 61388-05 for ; Thu, 21 Jun 2007 15:58:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from zoraida.natserv.net (p65-147.acedsl.com [66.114.65.147]) by postgresql.org (Postfix) with ESMTP id 7BF4F9FB77B for ; Thu, 21 Jun 2007 15:58:37 -0300 (ADT) Received: by zoraida.natserv.net (Postfix, from userid 58) id 51937C2EE; Thu, 21 Jun 2007 14:58:36 -0400 (EDT) Received: from 35st.simplicato.com (static-71-249-233-130.nycmny.east.verizon.net [71.249.233.130]) by zoraida.natserv.net (Postfix) with ESMTP id A32A8C2AF; Thu, 21 Jun 2007 14:58:33 -0400 (EDT) References: <357fa7590706211009w2ef6071fn83c5759db6be1e80@mail.gmail.com> Message-ID: X-Mailer: http://www.courier-mta.org/cone/ From: Francisco Reyes To: Steven Flatt Cc: pgsql-performance@postgresql.org Subject: Re: Database-wide VACUUM ANALYZE Date: Thu, 21 Jun 2007 14:58:33 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="ISO-8859-1" Content-Disposition: inline Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.282 tagged_above=0 required=5 tests=AWL=0.146, BAYES_50=0.001, FORGED_RCVD_HELO=0.135 X-Spam-Level: X-Archive-Number: 200706/485 X-Sequence-Number: 25518 Steven Flatt writes: > Can someone explain what is going on here?  I can't quite figure it out > based on the docs. Are you on FreeBSD by any chance? I think the FreeBSD port by default installs a script that does a daily vacuum. If using another OS, perhaps you want to see if you used some sort of package system and if that package added a nightly vacuum.