X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8FD9656A37 for ; Thu, 17 Mar 2005 21:20:26 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79085-08 for ; Thu, 17 Mar 2005 21:20:23 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 4F3A856A32 for ; Thu, 17 Mar 2005 21:20:21 +0000 (GMT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 17 Mar 2005 15:20:22 -0600 Subject: Re: Vacuum full on a big table From: Scott Marlowe To: Gaetano Mendola Cc: "pgsql-admin@postgresql.org" In-Reply-To: <4239F22C.4040401@bigfoot.com> References: <4239F22C.4040401@bigfoot.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1111094421.28555.244.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 17 Mar 2005 15:20:22 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/264 X-Sequence-Number: 16762 On Thu, 2005-03-17 at 15:10, Gaetano Mendola wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi all, > is there a way to vacuum full a table but working only > a part of the table ? I have a table with 6 milion rows > and vacuum full it will send out of line for hours my > server, so I'll like to vacuum that table multiple times > in order to not block that table for a long period. > > It will work decresing the FSM settings ? Vacuum full doesn't use fsm, lazy vacuum does (i.e. plain vacuum). Is there a reason you're doing a full vacuum? Like you forgot to vacuum for a while and now it needs it? If not, then a full vacuum is generally not necessary, and you're better off with regular vacuum and large enough fsm settings. Use vacuum analyze to see if you need to increase them. and no, you can't vacuum parts at a time. it's all or nothing. (*Unless that changes in 8.0...*)