On Mon, Nov 29, 2010 at 5:27 AM, AI Rumman <rumman...@gmail.com> wrote: > Full Text index is not using during OR operation for multiple table join:
Hmm. If you have a condition of the form <some-expression-involving-table-A> OR <some-expression-involving-table-B> ....then the system is going to have to join those tables before evaluating that condition. It can't scan A and throw away rows that don't match the first part of the condition, because they might match the second prong, and visca versa. You can sometimes speed these queries up by rewriting them as a UNION ALL query. Maybe it'd be nice to make the planner consider such plans automatically, but that'd be tricky to make work, I think. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
