X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D3CDE5E46DF for ; Wed, 18 Aug 2004 14:24:46 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 71356-03 for ; Wed, 18 Aug 2004 17:24:51 +0000 (GMT) Received: from quasar.skima.is (quasar.skima.is [212.30.200.205]) by svr1.postgresql.org (Postfix) with ESMTP id 42F2E5E46E2 for ; Wed, 18 Aug 2004 14:24:41 -0300 (ADT) Received: from wp2000 ([157.157.178.195] [157.157.178.195]) by quasar.skima.is; Wed, 18 Aug 2004 17:24:47 Z Message-Id: <00e801c48548$8d2c0b70$0100000a@wp2000> From: "gnari" To: "Thomas Swan" , "Igor Artimenko" Cc: References: <5DEC3FFCDE2F7C4DA45433EE09A4F22C01A3FFCA@colossus.dyadem.corp> <41238DFA.1030207@idigx.com> Subject: Re: I could not get postgres to utilizy indexes Date: Wed, 18 Aug 2004 17:26:52 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/277 X-Sequence-Number: 7913 "Thomas Swan" says: > Igor Artimenko wrote: > [ snipped question that was almost exactly a repeat of one we saw yesterday ] > > > > > Igor, you may want to run "vacuum analyze" and see if your results change. Actually, I think it was determined that the problem was due to the int index Michal Taborsky suggested this solution: select id from test where id = 50000::int8 did this not help ? gnari