Yeah, I have a lot of similar problems where an index that I have to
speed up one query is used in another query where it actually slows
it down. Is there any way to ignore indexes for certain queries?
We've been appending empty strings and adding zero's to the column
data to force it int
This is very similar to the problem I posted to this list
yesterday. Apparently, if you append an empty string to the column
data in your WHERE clause it will force the planer to treat it as a
filter and not an index cond. It's extremely ugly, but this method
doesn't seem to be anymore
Hello,
I'm experiencing some very unusual speed problems while executing a
particular query. Appending an empty string to one of the fields in
the query speeds up the execution by a 1000 fold. According to the
planner this alternate query is much more costly too. Here are the
EXPLAIN
