Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id D99D264FC41 for ; Mon, 8 Dec 2008 12:11:54 -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 67038-02 for ; Mon, 8 Dec 2008 12:11:48 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from gv-out-0910.google.com (gv-out-0910.google.com [216.239.58.190]) by mail.postgresql.org (Postfix) with ESMTP id 2742A64FC4E for ; Mon, 8 Dec 2008 12:11:47 -0400 (AST) Received: by gv-out-0910.google.com with SMTP id i36so207818gve.7 for ; Mon, 08 Dec 2008 08:11:47 -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:references; bh=XSLKC6WcmRSoiRcrlpzD0+wcXqeAqbq0MHZ0H3jS5hY=; b=sQgawiU0XV9g81OwOLYYb9LQGFaorpqzbWnACOSeprm3121/+QTm+XAuFZRzgkHnYr q7RzUzHyGGECOpcM4ynZ9VdVKu72EB5GFJ+0dflm51GZlSG4WxPcxx9eSzen+icWZmBA z+aDBYHEmS4AVuNLdz6K/89kkJfBC2DfcjpUQ= 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:references; b=nMerHAA8QvN64zr9n0Fw7EP7d9x5ASmpzLOzAQoGXdytD15sRtEypIS67UNGxdZz2C T3LeM3vTahg8NEDpRcUxGH+N5S1UFj6JW9t1kntif3dmTTbxdmIlOGNAfuc/Pw/MgRg4 FqSwRhS044ggoeQUqC4GDb9xcT6YPWKsvkLMs= Received: by 10.86.76.16 with SMTP id y16mr2731101fga.17.1228752707300; Mon, 08 Dec 2008 08:11:47 -0800 (PST) Received: by 10.86.83.10 with HTTP; Mon, 8 Dec 2008 08:11:47 -0800 (PST) Message-ID: <3a0028490812080811y2c6c2e94ta8bac4c46b1dd5ef@mail.gmail.com> Date: Mon, 8 Dec 2008 14:11:47 -0200 From: "Rafael Domiciano" To: "Scott Marlowe" Subject: Re: Vacuum Problems Cc: "Matthew T. O'Connor" , "Rafael Martinez" , "pgsql-admin@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_154614_12969708.1228752707292" References: <3a0028490811260543x74d02719w775a457999cfc74@mail.gmail.com> <492D5C87.5090505@usit.uio.no> <3a0028490811260700w6e8d9d86o24effbe0bea2bddb@mail.gmail.com> <3a0028490811260921l5d6aac06v54dca32aae672b97@mail.gmail.com> <492DA95D.3010303@zeut.net> <3a0028490812080504x22618c6fxd7df8febaadb1632@mail.gmail.com> 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: 200812/50 X-Sequence-Number: 30883 ------=_Part_154614_12969708.1228752707292 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline No, I'm gonna to try 2008/12/8 Scott Marlowe > On Mon, Dec 8, 2008 at 6:04 AM, Rafael Domiciano > wrote: > > Hello guys, > > I tried to modify my vacuum routine, and started to only run vacuum > verbose > > analyze diary followed by a reindex weekly. > > Have you tried running autovacuum with a naptime of 10 or 20? > ------=_Part_154614_12969708.1228752707292 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline No, I'm gonna to try

2008/12/8 Scott Marlowe <scott.marlowe@gmail.com>
On Mon, Dec 8, 2008 at 6:04 AM, Rafael Domiciano
<rafael.domiciano@gmail.com> wrote:
> Hello guys,
> I tried to modify my vacuum routine, and started to only run vacuum verbose
> analyze diary followed by a reindex weekly.

Have you tried running autovacuum with a naptime of 10 or 20?

------=_Part_154614_12969708.1228752707292--