Karl Denninger <k...@denninger.net> writes:
> That doesn't help in this case as the returned set will typically be
> quite large, with the condition typically being valid on anywhere from
> 10-80% of the returned tuples.
In that case you'd be wasting your time to get it to use an index
for the condition anyway. Maybe you need to take a step back and
look at the query as a whole rather than focus on this particular
condition.
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
