Re: Estimation problem with a LIKE clause containing a /

On 11/7/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I wanted the locale (lc_collate), not the encoding.

fr_FR.UTF-8

> That would optimize this particular query and probably pessimize
> a lot of others.

Sure but there aren't a lot of queries based on the ancestors field
and if they are a bit slower, it's not a problem. However having a
query taking forever is not acceptable as the content management app
is unaccessible.
So it can be an acceptable solution in this case, even if not perfect.

--
Guillaume