On 11/7/07, Tom Lane <tgl@xxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
