X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 67FBBD1B49E for ; Thu, 5 Feb 2004 17:08:49 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 84617-03 for ; Thu, 5 Feb 2004 13:08:41 -0400 (AST) Received: from anrath.info (anrath.info [217.160.130.42]) by svr1.postgresql.org (Postfix) with SMTP id 71DC1D1CB1D for ; Thu, 5 Feb 2004 13:08:39 -0400 (AST) Received: (qmail 25405 invoked by uid 1047); 5 Feb 2004 17:08:35 -0000 Received: from pd9e086d6.dip.t-dialin.net (HELO sturm64) (217.224.134.214) by anrath.info with SMTP; 5 Feb 2004 17:08:35 -0000 From: "Stefan Sturm" To: Subject: VACUUM Quesition Date: Thu, 5 Feb 2004 18:08:07 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: <40226E06.2080701@e-greek.net> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Thread-Index: AcPsBc6AibM2QIpBQ/+9q0TSXvxqwgABBdbA Message-Id: <20040205170839.71DC1D1CB1D@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=BAYES_44, RCVD_IN_NJABL, RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200402/59 X-Sequence-Number: 12233 Hello, I have a question about vaccum. There are thre Version of vaccums: 1.) plain vacuum 2.) vacuum analyze 3.) full vacuum Is it right that a vacuum analyze includes the plain vacuum and the full vacuum includes the vacuum analyze? And which vacuum locks the tables? And is there a strategy when to use which vacuum? I think I should do a full vacuum every night and a vacuum analyze sometimes a day. Is this OK? Greetings, Stefan Sturm