Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id B09491337BD8 for ; Wed, 30 Mar 2011 04:55:19 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 73313-03 for ; Wed, 30 Mar 2011 07:55:12 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.171]) by mail.postgresql.org (Postfix) with ESMTP id 321631337BD7 for ; Wed, 30 Mar 2011 04:55:12 -0300 (ADT) Received: from [192.168.1.6] (mail.highperformancepostgresql.com [71.179.240.8]) by mrelayeu.kundenserver.de (node=mrbap1) with ESMTP (Nemesis) id 0MY4Jc-1QQkoh2Zay-00Upbd; Wed, 30 Mar 2011 09:55:11 +0200 Message-ID: <4D92E1E0.4000207@2ndQuadrant.com> Date: Wed, 30 Mar 2011 03:55:12 -0400 From: Greg Smith User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.16) Gecko/20110307 Icedove/3.0.11 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Why Index is not used References: <4D8C37CA.3090601@orkash.com> <4D8C3FAB.7070001@orkash.com> <4D8C5881.4090806@orkash.com> <4D8C97A7.8030403@peak6.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:eZVzCnh/IPH1Ff5yI83xyPA+iZoiW49B7SUGer/z37w Rg6JstEUOsFwDk+DAWfrHdBVPHkJvehBmk8+kSaQRR85EWFR8U 67OWVpKwy3owD+k6u5k84wA20Rx+p5BExMSr7u5Jh4J4D7JmyV GGjXDX3Vn/KGxmj6NKDLkoV9b7MA59+qgca+op6JoPBn58Z/SG iUIKbQvtZpOx2YOSuqTFWN7lnuEdn81Am5i6oE/b8w= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201103/369 X-Sequence-Number: 43048 On 03/25/2011 12:49 PM, Maciek Sakrejda wrote: > Indexes aren't a magical performance fairy dust. One day I intend to use this line for the title of a presentation slide. Maybe the title of the whole talk. -- Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books