Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B814F6331AB for ; Thu, 19 Feb 2009 12:38:06 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 21904-03 for ; Thu, 19 Feb 2009 12:38:00 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.31]) by mail.postgresql.org (Postfix) with ESMTP id A65166331A7 for ; Thu, 19 Feb 2009 12:37:59 -0400 (AST) Received: by yw-out-2324.google.com with SMTP id 5so200626ywh.73 for ; Thu, 19 Feb 2009 08:37:57 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=UMs3eukJ/b2FHtn33AO3hDMUw0QZG4hX+2HKDHu5KJU=; b=rPc5bQDgbSoeINeJwqVJ4GdYP57IIf9UbYij3U24ZAJuL68rW2d6fgIndTxMNWtDub 9Gv6kQPGhLMph84g1YAvcVU7TNzvgLjq8pluaDATpn2700Ihdb0ijPucw7dwrPjG2ryd y61N00Y54mh33AH/IVazI6IvpRv4PtDb+Ov80= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=LvZlSu7MC9UpbeH7BX9Bu6/TqoKSh61l30x2UT97Q3ylPHzJ7cqTo4YV19XbauBszC vdq5Ok3pCHQvY1Kvnp4cmOdfdCxIrnK0KZ+vP3yOp7/AtZ40Hwj4f3hoYzcn83pQPOe3 JTZuc0sGhtUpp1Rmj1jE1aSlRB5pZUt3TbIvQ= MIME-Version: 1.0 Received: by 10.151.114.9 with SMTP id r9mr1106092ybm.205.1235061477518; Thu, 19 Feb 2009 08:37:57 -0800 (PST) In-Reply-To: <255907.92456.qm@web111313.mail.gq1.yahoo.com> References: <255907.92456.qm@web111313.mail.gq1.yahoo.com> Date: Thu, 19 Feb 2009 09:37:57 -0700 Message-ID: Subject: Re: vacuum full... From: Scott Marlowe To: Jessica Richard Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/146 X-Sequence-Number: 31367 On Thu, Feb 19, 2009 at 9:35 AM, Jessica Richard wrote: > I am running "vacuum full" via a shell script for a list of large databases > now... and I may run out of my scheduled system down time.... > > If I don't finish all databases and kill the script in the middle... am I > going to cause any table corruptions since "vacuum full" is rebuilding the > tables and indexes.... No. But may I ask why you are running vacuum full? Is it a regular thing. Do all your tables in all your dbs actually need it?