Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 64AA29FBD65 for ; Tue, 8 May 2007 18:43:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 70316-02 for ; Tue, 8 May 2007 18:43:02 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.247]) by postgresql.org (Postfix) with ESMTP id 2C54D9FBD48 for ; Tue, 8 May 2007 18:43:02 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id d17so249986and for ; Tue, 08 May 2007 14:43:01 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=sNOJqOlPk7vH+MuzJIDsZrs11OIiquzsDNrnqJ0zKI7iizk+60taQqZF3kB4ND9cDYEj4O3XZnGmmPWRfCBC8I6SD5mWAgUXk+GF3FuqT+Vbd67sDbFFL6LnnDRWBYW3iMuf6gsiHopheJYyxyZehnuxWfGOe44LiNELEPToU/c= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=I/d4gh2xQHTGEBlnt2lL/q47CqDmWuSI0SscndKyoRKgLUHJnsMNw34aES0fOjSoPtP11+9CinCO3gngjaNMMViySaUOaYJoyK0gk/+D62edU7n86uDkQYMeyF0Yu5GYSAJa3TdfL8N8LlDHq8vFoPU8v8Bw8Eo6Up5xqLPFT5M= Received: by 10.100.190.8 with SMTP id n8mr2852825anf.1178660580931; Tue, 08 May 2007 14:43:00 -0700 (PDT) Received: by 10.100.143.16 with HTTP; Tue, 8 May 2007 14:43:00 -0700 (PDT) Message-ID: Date: Tue, 8 May 2007 14:43:00 -0700 From: "Y Sidhu" To: pgsql-performance@postgresql.org Subject: What's The Difference Between VACUUM and VACUUM ANALYZE? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_119157_5579874.1178660580886" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/144 X-Sequence-Number: 24534 ------=_Part_119157_5579874.1178660580886 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline I am trying to follow a message thread. One guy says we should be running vacuum analyze daily and the other says we should be running vacuum multiple times a day. I have tried looking for what a vacuum analyze is to help me understand but no luck. -- Yudhvir Singh Sidhu 408 375 3134 cell ------=_Part_119157_5579874.1178660580886 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I am trying to follow a message thread. One guy says we should be running vacuum analyze daily and the other says we should be running vacuum multiple times a day. I have tried looking for what a vacuum analyze is to help me understand but no luck.

--
Yudhvir Singh Sidhu
408 375 3134 cell ------=_Part_119157_5579874.1178660580886--