El lunes 03 de diciembre, Tom Lane escribió:
> > Here are my queries:
>
> You sure you didn't paste in the same result for #2 and #3? They're
> the same plan with the same rows estimates --- but I'd expect the rows
> estimates, at least, to change given the more-selective LIKE pattern.
I don't know for sure if I have send wrong data, but I think not.
Tomorrow I'll get more info.
> Also, how many rows are there really that match '%DA%' and '%DAVID%'?
Very few for that incredible difference in time:
'%DA%' -> 2 sec.
'%DAVID%' -> 3 min.
> I suspect the planner is being overoptimistic about the selectivity of
> '%DAVID%', and is choosing a plan that doesn't work well when there are
> lots of DAVIDs :-(
I have thought that it only occurs when item to find is present
completely in any number of registers, but this is only a burde
hypothesis :?
Thanks for all.
David