"Jimmy Choi" <[EMAIL PROTECTED]> writes: > A simple query is executing much slower than expected. When looking at > the query plan, I see a bitmap index scan on a partial index that does > not have any associated index condition. How could that happen?
Easily --- it thinks that the partial index predicate is useful in itself. > "vacuum analyze" doesn't solve the problem. I'm running 8.1.5. choose_bitmap_and was rewritten (again) in 8.1.9. Try a newer version. http://archives.postgresql.org/pgsql-committers/2007-04/msg00233.php regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
