Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id C6D81633066 for ; Thu, 19 Feb 2009 12:35:42 -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 18389-06 for ; Thu, 19 Feb 2009 12:35:39 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from n78.bullet.mail.sp1.yahoo.com (n78.bullet.mail.sp1.yahoo.com [98.136.44.42]) by mail.postgresql.org (Postfix) with SMTP id 1B229632FF6 for ; Thu, 19 Feb 2009 12:35:17 -0400 (AST) Received: from [216.252.122.218] by n78.bullet.mail.sp1.yahoo.com with NNFMP; 19 Feb 2009 16:19:38 -0000 Received: from [67.195.9.83] by t3.bullet.sp1.yahoo.com with NNFMP; 19 Feb 2009 16:35:16 -0000 Received: from [67.195.9.108] by t3.bullet.mail.gq1.yahoo.com with NNFMP; 19 Feb 2009 16:35:16 -0000 Received: from [127.0.0.1] by omp112.mail.gq1.yahoo.com with NNFMP; 19 Feb 2009 16:35:16 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 461879.27709.bm@omp112.mail.gq1.yahoo.com Received: (qmail 23756 invoked by uid 60001); 19 Feb 2009 16:35:16 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1235061316; bh=oL/jNdoX+d3GMuuhJJyPg9AQL5q783xOhY000oKJHGs=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=xUfy3erTkASiKMGTfK9R9lFCpzRTkXx0TAwvYTc490YgFvZZ6BGVHOQDDWU/PLdijZ6/Gm3zZ4SBQAXMEkp3jN8xE5dX3ILWgFvnmKSr3Fc2fX2onR4fzkoCdcEFAyc/NzOfp9S0VaqJGgLQyHH8JFT6fFscaKrlyUnGKhWt0JM= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=Np0rv3hyFbjST69WYLQdW3igK58492DtFLK97uSEexGvXudm4VQDLFTOdSb5Vy18tETMQuVwaoc2k1GIBOOWE4Lwno/WQt8pXNrzRvJC2kaGXVCfPRjAHIw42fTRbI5mNda/rLi6YQ47OHFY4NB7lN8OTwfuBEX3S745sOVTOpo=; Message-ID: <255907.92456.qm@web111313.mail.gq1.yahoo.com> X-YMail-OSG: FhQjGmcVM1kU.PdipzTcqtNS8oBDnRlX04PooShMXHNbHdD4Bo8- Received: from [198.119.134.32] by web111313.mail.gq1.yahoo.com via HTTP; Thu, 19 Feb 2009 08:35:15 PST X-Mailer: YahooMailRC/1155.45 YahooMailWebService/0.7.289.1 Date: Thu, 19 Feb 2009 08:35:15 -0800 (PST) From: Jessica Richard Subject: vacuum full... To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-990431964-1235061315=:92456" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200902/145 X-Sequence-Number: 31366 --0-990431964-1235061315=:92456 Content-Type: text/plain; charset=us-ascii 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.... thanks, Jessica --0-990431964-1235061315=:92456 Content-Type: text/html; charset=us-ascii
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....

thanks,
Jessica


--0-990431964-1235061315=:92456--