Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D0D749FB440 for ; Sun, 18 Feb 2007 04:35:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 14353-07 for ; Sun, 18 Feb 2007 04:35:14 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id 30B5A9FB3C5 for ; Sun, 18 Feb 2007 04:35:14 -0400 (AST) Received: from root by ciao.gmane.org with local (Exim 4.43) id 1HIhVe-00058H-Rt for pgsql-admin@postgresql.org; Sun, 18 Feb 2007 09:35:03 +0100 Received: from ppp-82-135-2-76.dynamic.mnet-online.de ([82.135.2.76]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 18 Feb 2007 09:35:02 +0100 Received: from spam_eater by ppp-82-135-2-76.dynamic.mnet-online.de with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 18 Feb 2007 09:35:02 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: Thomas Kellerer Subject: Re: How to analyse the indexes in postgres? Date: Sun, 18 Feb 2007 09:21:03 +0100 Lines: 8 Message-ID: References: <20070204223032.GA97725@winnie.fuhr.org> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: ppp-82-135-2-76.dynamic.mnet-online.de User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.0.9) Gecko/20061207 Thunderbird/1.5.0.9 Mnenhy/0.7.4.0 In-Reply-To: Cc: pgsql-php@postgresql.org,pgsql-sql@postgresql.org Cc: pgsql-php@postgresql.org,pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.47 tagged_above=0 required=5 tests=AWL, BAYES_50, SPF_HELO_PASS, SPF_PASS, SUSPICIOUS_RECIPS X-Spam-Level: * X-Archive-Number: 200702/261 X-Sequence-Number: 24726 Karthikeyan Sundaram wrote on 18.02.2007 09:15: > Hi, > > I am new to postgres. I need some kind of template script or advise > on how to analyse the indexes. In our database, we do delete, insert, > update tons of rows. > http://www.postgresql.org/docs/8.2/interactive/routine-reindex.html