Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C94A19FB2C7 for ; Sun, 18 Feb 2007 09:27:52 -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 88282-08 for ; Sun, 18 Feb 2007 09:27:49 -0400 (AST) X-Greylist: delayed 00:28:02.520487 by SQLgrey-1.7.4 Received: from tiggs.net (206-223-169-74.beanfield.net [206.223.169.74]) by postgresql.org (Postfix) with ESMTP id CC5319FB1E6 for ; Sun, 18 Feb 2007 09:27:49 -0400 (AST) Received: from localhost (206-223-169-82.beanfield.net [206.223.169.82]) by tiggs.net (Postfix) with ESMTP id B9DB227E4F5; Sun, 18 Feb 2007 06:59:46 -0600 (CST) Received: from tiggs.net ([206.223.169.74]) by localhost (mx1.hub.org [206.223.169.82]) (amavisd-new, port 10024) with ESMTP id 50954-07; Sun, 18 Feb 2007 12:59:46 +0000 (UTC) Received: from [10.0.1.100] (cpe-74-69-92-35.rochester.res.rr.com [74.69.92.35]) by tiggs.net (Postfix) with ESMTP id 0919527E4A7; Sun, 18 Feb 2007 06:59:43 -0600 (CST) Message-ID: <45D84DB9.1050202@tiggs.net> Date: Sun, 18 Feb 2007 07:59:37 -0500 From: Charley Tiggs User-Agent: Thunderbird 1.5.0.9 (Macintosh/20061207) MIME-Version: 1.0 To: Karthikeyan Sundaram CC: pgsql-php@postgresql.org Subject: Re: How to analyse the indexes in postgres? References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200702/23 X-Sequence-Number: 3706 What version of Postgres are you using? Charley Karthikeyan Sundaram wrote: > 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. > > Regards > skarthi > > _________________________________________________________________ > Refi Now: Rates near 39yr lows! $430,000 Mortgage for $1,399/mo - > Calculate new payment > http://www.lowermybills.com/lre/index.jsp?sourceid=lmb-9632-17727&moid=7581 > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend >