X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 818DD9DC945 for ; Thu, 5 Jan 2006 11:48:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13926-05 for ; Thu, 5 Jan 2006 11:48:05 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.192]) by postgresql.org (Postfix) with ESMTP id 240919DC960 for ; Thu, 5 Jan 2006 11:47:57 -0400 (AST) Received: by wproxy.gmail.com with SMTP id 57so2598379wri for ; Thu, 05 Jan 2006 07:48:03 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=GCAWhLliKQ8Fe7zrcGxmyUeWnCQi7s94hQG2+SpypS0GPThnt+x79BgFFg+NyikwyIM36Zv/m+PAhlgJzscBs3/SbgsZtvgwBKrJTtkkzj6rLvYvMlJTSt1aKz6iTvdiEZOLXUmWm4xPtgpUHwQiHaNBtx56mCvIfNqoXrzo99w= Received: by 10.54.113.6 with SMTP id l6mr4032090wrc; Thu, 05 Jan 2006 07:48:02 -0800 (PST) Received: by 10.54.92.14 with HTTP; Thu, 5 Jan 2006 07:48:02 -0800 (PST) Message-ID: Date: Thu, 5 Jan 2006 10:48:02 -0500 From: Jaime Casanova To: Szabolcs BALLA Subject: Re: Vacuum is needed or not? Cc: postgre In-Reply-To: <1136475086.4221.48.camel@bh> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <1136466721.4221.39.camel@bh> <1136475086.4221.48.camel@bh> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.083 required=5 tests=[AWL=0.083] X-Spam-Score: 0.083 X-Spam-Level: X-Archive-Number: 200601/71 X-Sequence-Number: 20159 On 1/5/06, Szabolcs BALLA wrote: > > VACUUM is needed at least every billion transactions... execute it in a > script periodically... if you are in doubt if you need VACUUM then you need > it urgently, execute it right now!!! > > yes, and i running every weekend a full analyze, but actually i think it'= s > need again, but just for feel i couldn't stop the server. > I need evidence. (oldspice rulez ;)) > > Szabek a plain VACUUM (without full) is enough in most cases... and you don't need to stop the server for a plain VACUUM... -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)