X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id DB338D1B4F2 for ; Tue, 16 Sep 2003 07:45:22 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 41487-04 for ; Tue, 16 Sep 2003 04:44:53 -0300 (ADT) Received: from curry.tmsl.demon.co.uk (tmsl-adsl.demon.co.uk [80.177.114.181]) by svr1.postgresql.org (Postfix) with ESMTP id D0361D1B500 for ; Tue, 16 Sep 2003 04:44:50 -0300 (ADT) Received: from bacon.tmsl.demon.co.uk (bacon.tmsl.demon.co.uk [192.168.7.102]) by curry.tmsl.demon.co.uk (8.11.6/8.11.6) with ESMTP id h8G7ina09299 for ; Tue, 16 Sep 2003 08:44:50 +0100 Date: Tue, 16 Sep 2003 08:44:48 +0100 From: Paul Thomas To: "pgsql-performance @ postgresql . org" Subject: Re: Attempt at work around of int4 query won't touch int8 index ... Message-ID: <20030916084448.A24702@bacon> References: <2756862E-E3F5-11D7-8513-000A9566A412@socialserve.com> <20901.1063248257@sss.pgh.pa.us> <3F65BABC.32672.38837688@localhost> Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset=ISO-8859-1 In-Reply-To: <3F65BABC.32672.38837688@localhost>; from shridhar_daithankar@persistent.co.in on Mon, Sep 15, 2003 at 08:42:28 +0100 X-Mailer: Balsa 1.2.3 Lines: 27 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/233 X-Sequence-Number: 3599 On 15/09/2003 08:42 Shridhar Daithankar wrote: > > Is it possible to follow data type upgrade model in planner? Something > like in > C/C++ where data types are promoted upwards to find out better plan? > > int2->int4->int8->float4->float8 types. > > That could be a clean solution.. > > just a thought.. > Interestingly, float8 indexes do work OK (float8col = 99). I spend a large part of yesterday grepping through the sources to try and find out why this should be so. No luck so far but I'm going to keep on trying! -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for the Smaller Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+