Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id C00BB64FE03
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 26 Nov 2008 13:33:21 -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 05294-02 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 26 Nov 2008 13:33:19 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from wa-out-1112.google.com (wa-out-1112.google.com
 [209.85.146.183])
	by mail.postgresql.org (Postfix) with ESMTP id D3D3C64FD32
	for <pgsql-admin@postgresql.org>; Wed, 26 Nov 2008 13:33:17 -0400 (AST)
Received: by wa-out-1112.google.com with SMTP id j4so280009wah.19
	for <pgsql-admin@postgresql.org>; Wed, 26 Nov 2008 09:33:16 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:cc:in-reply-to:mime-version:content-type
	:content-transfer-encoding:content-disposition:references;
	bh=Ke2EXyJVna3qIvMcKOWWgB6A0m2daJPCmRQj7euuBPI=;
	b=vUO6v/nzkMSYzX0RwK7K6fJuI5QjaxE3ntZJprOdRHbh3qgxmlU4EENzWfbcgwCsty
	cUENYO2RjZLZB8KJrY7CTpV8JMAmj7adJhSiM2FDRGt5kH9MoeJBSvRnKlKGRMrkkutR
	Mmu7LrHenrVkqwBCe5c7AaOyv+Sj1gH5aSiFo=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=s/lM6CP/DggOkX3AppP9dTlimTHkciHi92CDyo0NAm53A68bEhBuQFU6f5UGqHl/lG
	JHznD7h1ga6eYrYvbxqcNtFShsCVVF+Reaf2fwuzeOc9Thxg1RaCNbviKgwok8AN8Ezt
	+mL8f5cye4TNhJp5GuWqi7V1knTINvzx4fy98=
Received: by 10.114.56.1 with SMTP id e1mr3499865waa.19.1227720796736;
	Wed, 26 Nov 2008 09:33:16 -0800 (PST)
Received: by 10.114.190.12 with HTTP; Wed, 26 Nov 2008 09:33:16 -0800 (PST)
Message-ID: <dcc563d10811260933i398d8573jcde3f293015f709a@mail.gmail.com>
Date: Wed, 26 Nov 2008 10:33:16 -0700
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "Rafael Domiciano" <rafael.domiciano@gmail.com>
Subject: Re: Vacuum Problems
Cc: "Rafael Martinez" <r.m.guerrero@usit.uio.no>,
	"pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: <3a0028490811260921l5d6aac06v54dca32aae672b97@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <3a0028490811260543x74d02719w775a457999cfc74@mail.gmail.com>
	<492D5C87.5090505@usit.uio.no>
	<3a0028490811260700w6e8d9d86o24effbe0bea2bddb@mail.gmail.com>
	<dcc563d10811260740m69f8969bt36be6ae675620dcb@mail.gmail.com>
	<3a0028490811260921l5d6aac06v54dca32aae672b97@mail.gmail.com>
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: 200811/154
X-Sequence-Number: 30808

On Wed, Nov 26, 2008 at 10:21 AM, Rafael Domiciano
<rafael.domiciano@gmail.com> wrote:
> I'm not using autovacuum. Regular vacuum goes ok.
> To see the last 10 lines of verbose i will need to run vacuum tonight
> If a run a reindex before the vacuum full, increase the "speed" of doing
> vacuum? I found something about it googling.

You should look into enabling autovac.  You can set the sleep
parameter to 10 or 20 to keep it from hogging your I/O bandwidth.
Also, reindex AFTER the vacuum full, not before.