Karl Denninger <karl@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
