>>> On Sat, Oct 6, 2007 at 11:28 AM, in message <[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> wrote:
> I've been wondering
> if it would be worth the trouble to introduce scalarlesel and
> scalargesel estimators ...
FWIW, this is an issue we ran into:
http://archives.postgresql.org/pgsql-performance/2006-03/msg00211.php
We worked around it in our framework by checking for a range with equal
values and converting to an equality test before presenting it to the
database.
-Kevin
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
