Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 76E3264FE03 for ; Wed, 26 Nov 2008 11:40:47 -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 79568-08 for ; Wed, 26 Nov 2008 11:40:44 -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.172]) by mail.postgresql.org (Postfix) with ESMTP id 4D58364FD32 for ; Wed, 26 Nov 2008 11:40:43 -0400 (AST) Received: by wf-out-1314.google.com with SMTP id 25so516665wfc.28 for ; Wed, 26 Nov 2008 07:40:41 -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=o6qgrtWu0TPXV2ii4xPiYZsvoN26IhapOrKEvOZ2zjM=; b=I4Vnw6qxIDc9B00t4L5FU6kU4YMwR4dDp3tIl3CxmXw68twZn8t96Us2prLheZ5cTp KF/PsNxFhu/LrNhzk2qe4J/1DTqjXpqerWPFLGVhSk8JrFExZIAtHTjlIl3MYZ5DGiO8 wYpB/56RXdI839kL9aJ4h5yu8KhtOzztPXMO4= 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=OFg0hJEgKavgV6pscp+pH7R4aWR3TBdVqyWNskBEaKsSQI78Cpk5fxnVo0CpDEzC9M twU21Mo/EpXkTCxfwYdEoC9inO9NV2YX0rP2Z3rL4wbzKOYlVAA5Q3J1vIChno/rj2Zw EH8Vig2U5uYJxd+JFOPH53ss85oioOlm4aTlk= Received: by 10.114.37.9 with SMTP id k9mr3401694wak.197.1227714041542; Wed, 26 Nov 2008 07:40:41 -0800 (PST) Received: by 10.114.190.12 with HTTP; Wed, 26 Nov 2008 07:40:41 -0800 (PST) Message-ID: Date: Wed, 26 Nov 2008 08:40:41 -0700 From: "Scott Marlowe" To: "Rafael Domiciano" Subject: Re: Vacuum Problems Cc: "Rafael Martinez" , "pgsql-admin@postgresql.org" In-Reply-To: <3a0028490811260700w6e8d9d86o24effbe0bea2bddb@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> 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/151 X-Sequence-Number: 30805 2008/11/26 Rafael Domiciano : > The database has around 40 Gb. > If I not use vacuum full everyday the database get very slow. > > There is no deadlock on the database. You didn't mention if you were using autovacuum or not. You also didn't mention whether or not you'd tried regular vacuums if for some reason you can't use autovacuum. Vacuum full is very intrusive and can cause index bloat. It's more of a repair operation than a routine maintenance one. What do the last 10 or so lines of vacuum verbose run as a super user say?