| From: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | "pgsql-performance (at) postgresql (dot) org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Attempt at work around of int4 query won't touch int8 index ... |
| Date: | 2003-09-16 07:44:48 |
| Message-ID: | 20030916084448.A24702@bacon |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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 |
+------------------------------+---------------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matt Clark | 2003-09-16 08:31:01 | Re: Inconsistent performance |
| Previous Message | Manfred Koizar | 2003-09-16 07:09:05 | Re: Inconsistent performance |