Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 296F8633142 for ; Thu, 19 Feb 2009 16:11:43 -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 57057-01 for ; Thu, 19 Feb 2009 16:11:39 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.170]) by mail.postgresql.org (Postfix) with ESMTP id 89DB3632E2D for ; Thu, 19 Feb 2009 16:11:39 -0400 (AST) Received: by wf-out-1314.google.com with SMTP id 23so646783wfg.28 for ; Thu, 19 Feb 2009 12:11:37 -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=aGI6dQuZYq0pBr1LcrbiqoZcwjJfh16B7zH4eCjKrd8=; b=OFUyxNitqmMFVTqbgbmhWYhycnepqvfrMJYQURZaMr3EHBaT0fonnpgwXwLaUsvRcO xOSKDSKh+zZy5X+4OYeRNszhgQMcytirXNztU8DQvKWPNdoqepo1J+qc8qPQeJ1sIRg5 GqNELELRkLoDmtggWAcAFU25CDHY1pH2Mkx/M= 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=j2NavIDM1RPdmpJTAsK6SyTTSgIYKNh6XateTnUERm+WDRT+12cSlLStEtogkMpiWc 5UvGDcxHLL8pjj5xoGQe6BzLcRfqsWEkVs5zTKMAElTzgzgfyBzMWrmOJo3yn/HS4/Pl D6dv7DmeyJgBTPbTuC7sA1z35EGN67o0nPV+o= MIME-Version: 1.0 Received: by 10.114.130.8 with SMTP id c8mr3863531wad.15.1235074297828; Thu, 19 Feb 2009 12:11:37 -0800 (PST) In-Reply-To: <3a0028490902191001i2057a5ebs1e77b0f8ebf556bb@mail.gmail.com> References: <255907.92456.qm@web111313.mail.gq1.yahoo.com> <3a0028490902191001i2057a5ebs1e77b0f8ebf556bb@mail.gmail.com> Date: Thu, 19 Feb 2009 13:11:37 -0700 Message-ID: Subject: Re: vacuum full... From: Scott Marlowe To: Rafael Domiciano Cc: Jessica Richard , 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/148 X-Sequence-Number: 31369 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?