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