Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9A96F633066 for ; Thu, 19 Feb 2009 14:02:01 -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 11042-09 for ; Thu, 19 Feb 2009 14:01:57 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yx-out-2324.google.com (yx-out-2324.google.com [74.125.44.30]) by mail.postgresql.org (Postfix) with ESMTP id 6D16F63317A for ; Thu, 19 Feb 2009 14:01:57 -0400 (AST) Received: by yx-out-2324.google.com with SMTP id 3so218640yxj.73 for ; Thu, 19 Feb 2009 10:01:56 -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; bh=7ikjErZainoJ8b1pbOclqkTM+yWPpJzrfyxDTDzLAyM=; b=Yh3XY4+xg9GhaX/BGDbJxe4wmqZmzBPQPXrmsScwBlVMja16DTbT80TzfiHDt8Cc7j D1rUE8DASabayr3EbP/LS1p7hsUO/Tv8Np9ljjxw+FN2PTGo1bvEv/Sj9nQthSqBw4bL cMlA7qasargnQw+TTjG7PSZ/3x3Zmbv29F/Ts= 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; b=qydnf2YW3gPNytfdrpCHnnvWlEaI5hba/oq/YM+hAWNALD7q8n0Lrbt/fURrULkBui KpP8je0xmqQFxw3o1Mve8h59ttn4SurCnJZrDOR5GlWXSErtRvwhRQTcd3zf0vXxdzQ+ s+jwKlSbAvuDS4Qw3nDvI4VbZh5aRSMzu+bAI= MIME-Version: 1.0 Received: by 10.150.211.4 with SMTP id j4mr527149ybg.53.1235066516645; Thu, 19 Feb 2009 10:01:56 -0800 (PST) In-Reply-To: References: <255907.92456.qm@web111313.mail.gq1.yahoo.com> Date: Thu, 19 Feb 2009 15:01:56 -0300 Message-ID: <3a0028490902191001i2057a5ebs1e77b0f8ebf556bb@mail.gmail.com> Subject: Re: vacuum full... From: Rafael Domiciano To: Scott Marlowe Cc: Jessica Richard , pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=000e0cd48650ffa90504634954bd 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/147 X-Sequence-Number: 31368 --000e0cd48650ffa90504634954bd Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit I used to run vacuum full in one of my bases, but now i'm not running anymore vacuum full, just vacuum analyze in the past 1 month, but the number of necessary pages is increasing every day, now it's in 311264... there is any problem this get increasing? When I runned Reindex few days ago, this number get not decreased. I now that vacuum full reorders the relation, but it's the only thing that it does? Thnks, Rafael Domiciano On Thu, Feb 19, 2009 at 1:37 PM, Scott Marlowe wrote: > 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? > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > --000e0cd48650ffa90504634954bd Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I used to run vacuum full in one of my bases, but now i'm not running a= nymore vacuum full, just vacuum analyze in the past 1 month, but the number= of necessary pages is increasing every day, now it's in 311264... ther= e is any problem this get increasing?
When I runned Reindex few days ago, this number get not decreased.
I now= that vacuum full reorders the relation, but it's the only thing that i= t does?

Thnks,

Rafael Domiciano

On Thu, Feb 19, 2009 at 1:37 PM, Scott Marlowe <scott.marlowe@gmail.com>= wrote:
On Thu, Feb 19, 2009 at 9:35 AM, Jess= ica Richard <rjessil@yahoo.com&= gt; 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?

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--000e0cd48650ffa90504634954bd--