Re: explicit casting required for index use - Mailing list pgsql-performance

From Neil Conway
Subject Re: explicit casting required for index use
Date
Msg-id 1067246333.457.12.camel@tokyo
Whole thread Raw
In response to explicit casting required for index use  (Reece Hart <reece@in-machina.com>)
List pgsql-performance
On Sat, 2003-10-25 at 13:49, Reece Hart wrote:
> Having to explicitly cast criterion is very non-intuitive. Moreover,
> it seems quite straightforward that PostgreSQL might incorporate casts

This is a well-known issue with the query optimizer -- search the
mailing list archives for lots more information. The executive summary
is that this is NOT a trivial issue to fix, and it hasn't been fixed in
7.4, but there is some speculation on how to fix it at some point in the
future.

-Neil



pgsql-performance by date:

Previous
From: Dror Matalon
Date:
Subject: Re: Various performance questions
Next
From: Manfred Koizar
Date:
Subject: Re: Performance Concern