Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id A2EA29FB661; Sun, 18 Feb 2007 04:15:13 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 54264-07-3; Sun, 18 Feb 2007 04:15:08 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc3-s6.bay0.hotmail.com (bay0-omc3-s6.bay0.hotmail.com [65.54.246.206]) by postgresql.org (Postfix) with ESMTP id A6D359FB617; Sun, 18 Feb 2007 04:15:08 -0400 (AST) Received: from hotmail.com ([65.55.136.118]) by bay0-omc3-s6.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Sun, 18 Feb 2007 00:15:07 -0800 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Sun, 18 Feb 2007 00:15:07 -0800 Message-ID: Received: from 65.55.136.123 by by131fd.bay131.hotmail.msn.com with HTTP; Sun, 18 Feb 2007 08:15:01 GMT X-Originating-IP: [67.169.184.232] X-Originating-Email: [skarthi98@hotmail.com] X-Sender: skarthi98@hotmail.com In-Reply-To: <20070204223032.GA97725@winnie.fuhr.org> From: "Karthikeyan Sundaram" To: pgsql-sql@postgresql.org, pgsql-php@postgresql.org, pgsql-admin@postgresql.org Subject: How to analyse the indexes in postgres? Date: Sun, 18 Feb 2007 00:15:01 -0800 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 18 Feb 2007 08:15:07.0009 (UTC) FILETIME=[E645D710:01C75334] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.722 tagged_above=0 required=5 tests=BAYES_40, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, MSGID_FROM_MTA_HEADER, SPF_PASS X-Spam-Level: * X-Archive-Number: 200702/260 X-Sequence-Number: 24725 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