Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id CA75164FCF5 for ; Fri, 12 Sep 2008 16:55:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 13220-01 for ; Fri, 12 Sep 2008 16:55:27 -0300 (ADT) 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.168]) by postgresql.org (Postfix) with ESMTP id 1BDF164FCD3 for ; Fri, 12 Sep 2008 16:55:26 -0300 (ADT) Received: by wf-out-1314.google.com with SMTP id 25so901628wfc.28 for ; Fri, 12 Sep 2008 12:55:24 -0700 (PDT) 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=QScHKDDus4cvIcHY3G5RHxcCJ9Ho5CNFc4s21FDOpDE=; b=DkqmV6ZKnXYnEYhtzH1KNUQ4Nqtftu/CF3SgZG5uVCD1PUTeFmFFrJiCVrN793d5yJ WgNMo4jlOcQvWI8XsCURyWukqni0jCOY+KWF53EmKSAlbI5MmmqDm5XDLte2LgRsMe3q s/q4oMZv4MF+KC1D+1dR1mI4xPbEYeOYi1e1Q= 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=WcyLZ28H6BLLBLSDURJnmp7JIOQ3+pGFQJH4xKbWe3VbprlFspp7SK4DqT0NT+RaE/ S68qtMLaHfKMoN+WQR/+xPrbSS/+GPznpXoeWeCkhbsEZNSN45NWV+M5YZoWmi7whvYQ 0bRaLpsOa56SnC+yAfdW8GdwFsmaT7mSRIqo4= Received: by 10.140.249.20 with SMTP id w20mr2883138rvh.189.1221249324007; Fri, 12 Sep 2008 12:55:24 -0700 (PDT) Received: by 10.141.74.11 with HTTP; Fri, 12 Sep 2008 12:55:23 -0700 (PDT) Message-ID: Date: Fri, 12 Sep 2008 13:55:23 -0600 From: "Scott Marlowe" To: Fabricio Subject: Re: Recommend dba maintenance tasks on a regular bases Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <200809121149.46137.barbara@turbocorp.com> <20080912164019.GD2171@commandprompt.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: 200809/124 X-Sequence-Number: 30217 On Fri, Sep 12, 2008 at 12:51 PM, Fabricio wrote: > > I have a reindex of my databases periodically > > Sorry for the English translation of google > I have PostgreSQL 8.1.x > The databases that we have has many updates and were being slow, revising > found that some index were bigger than it should be, did not agree to the > size of the table. I made a reindex of the table and consultation is his > much faster and the index remained very small. > We therefore began a scheduled task that reidex my batadase periodically. This is generally a sign you aren't vacuuming aggresively enough. some usage patterns, however, lend themselves to off hours vacuuming instead of during the day. If your machine doesn't have enough bandwidth to handle vacuuming during the day, then it's probably better in the long run to look at faster I/O subsystems.