Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id C83B5634FB1 for ; Fri, 20 Feb 2009 09:36:40 -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 54409-04 for ; Fri, 20 Feb 2009 09:36:37 -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 71B4E634FC5 for ; Fri, 20 Feb 2009 09:36:37 -0400 (AST) Received: by yw-out-2324.google.com with SMTP id 5so361399ywh.73 for ; Fri, 20 Feb 2009 05:36:35 -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=poVIqR8IqxCQRP6Ka33oaE3d867+9eX4MLW23rM5bxA=; b=uw4139vGRFRX6BtPmWWkL/I8mcvLnvkqjs/hVlSMdVhrO1qMfTUt5TNbwNVnYMRUvX TQfmom/QrqTMzsXGbrDxVlUIo21xC86l1LB19mYFsm209qPl+qx5DoXU6WS1dGiqbEo/ qWFj10Xg7UjJ8Qax0Iy6EK3xlUz3IXjcOIQcs= 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=T8cR2vKdCEj3Lobe+spO8UpToHh62mDI/sJrCgiUh5VkATlk+W6jKMHq8fAmPtZk3e x2ZtfxdvzSnZRgszcBWUqrddmAJwRLKVjhgVsZi7R4POALGDZ1Yj4rHQKXANqt3QNN6U ieUOkCeO5jO1ZtnkuHcei17UP+/jQiT7Vs/Z8= MIME-Version: 1.0 Received: by 10.151.108.13 with SMTP id k13mr1980146ybm.3.1235129808561; Fri, 20 Feb 2009 03:36:48 -0800 (PST) In-Reply-To: References: <255907.92456.qm@web111313.mail.gq1.yahoo.com> <3a0028490902191001i2057a5ebs1e77b0f8ebf556bb@mail.gmail.com> Date: Fri, 20 Feb 2009 08:36:48 -0300 Message-ID: <3a0028490902200336ha7b42cv6b87b12fa062378e@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=0015175744987da534046358112a 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/153 X-Sequence-Number: 31374 --0015175744987da534046358112a Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit I don't have too much delete and update in the middle of the day to run autovacuum, but in the night, before vacuum analyze, there is some proccess that does delete and update, then run vacuum analyze. On Thu, Feb 19, 2009 at 5:11 PM, Scott Marlowe wrote: > On Thu, Feb 19, 2009 at 11:01 AM, Rafael Domiciano > wrote: > > 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? > > Same question I had for the other poster, why are you not running > autovacuum? Has it proven itself not up to the task? > --0015175744987da534046358112a Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I don't have too much delete and update in the middle of the day to run= autovacuum, but in the night, before vacuum analyze, there is some procces= s that does delete and update, then run vacuum analyze.

On Thu, Feb 19, 2009 at 5:11 PM, Scott Marlowe <scott.marlowe@gmail.com>= wrote:
On Thu, Feb 19, 2009 at 11:01 AM, Rafael Domiciano <rafael.domiciano@gmail.co= m> wrote:
> I used to run vacuum full in one of my bases, but now i'm not runn= ing
> 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 th= ing that
> it does?

Same question I had for the other poster, why are you not running
autovacuum?  Has it proven itself not up to the task?

--0015175744987da534046358112a--