Hello, I have a question regarding Postgres 8.2 and the planner. Our company's application runs searches with "like" where clauses, for example: "where id like '38F20A%'". This query once ran in under 10 ms, but since upgrading from 8.1.3 to 8.2.0, it now takes about 500 ms to run. The problem appears to be that the planner does not want to use an index since the upgrade, for "like" queries. We experimented with planner cost constants, and we even tried setting enable_seqscan to false. A seq scan was done every time. Now if my understanding is correct, setting enable_seqscan to false should tell the planner never to use a seq scan unless no alternative is possible. We made sure the relevant index still exists, of course, and that the table was analyzed with good samples... Could this be a bug, or am I the problem? :) Any advice or insight is appreciated. Thank you, Mark
