On 1/10/11 7:25 AM, Tom Lane wrote: > I'm a bit worried though that there might be other > cases where the estimator comes up with 1.0 selectivity but it'd still > be worth considering a bitmap scan.
Well, I think the answer is to apply the other fixes, and test. If there are other cases of selectivity=1.0, they'll show up. People are pretty fast to complain if indexes aren't used, and we have a good production test case available once you implement the other operators. -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers