X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id 31DFFCC943 for ; Thu, 17 Jul 2003 11:16:34 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 71530-05 for ; Thu, 17 Jul 2003 11:16:58 +0000 (GMT) Received: from smtp.pspl.co.in (unknown [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id 36F19CC8FB for ; Thu, 17 Jul 2003 08:16:31 -0300 (ADT) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id h6HBKwtR019868 for ; Thu, 17 Jul 2003 16:50:58 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) (authenticated bits=0) by smtp.pspl.co.in (8.12.9/8.12.9) with ESMTP id h6HBKwuf019854 for ; Thu, 17 Jul 2003 16:50:58 +0530 From: "Shridhar Daithankar" To: pgsql-performance@postgresql.org Date: Thu, 17 Jul 2003 16:48:42 +0530 MIME-Version: 1.0 Subject: Re: index / sequential scan problem Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3F16D36A.20463.3954D1@localhost> In-reply-to: <5.1.0.14.0.20030717130132.0397b6b0@195.145.148.245> References: <3F16B712.19311.58D7530@localhost> X-mailer: Pegasus Mail for Windows (v4.12a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/249 X-Sequence-Number: 2542 On 17 Jul 2003 at 13:12, Fabian Kreitner wrote: > At 11:17 17.07.2003, Shridhar Daithankar wrote: > >How about > > > > where ma_id = 2001::integer > >and ma_pid = 1097::integer > > > >in above query? > > I dont really understand in what way this will help the planner but ill try. That is typecasting. It helps planner understand query in more correct fashion. Bye Shridhar -- QOTD: "I may not be able to walk, but I drive from the sitting posistion."