Ok, a little investigation on locale support turned up an ugly fact. Here is quote from the documentation on locale:
"The only severe drawback of using the locale support in PostgreSQL is its speed. So use locale only if you actually need it. It should be noted in particular that selecting a non-C
locale disables index optimizations for LIKE and ~ operators, which can make a huge difference in the speed of searches that use those operators."
This a big problem for openacs, as we rely on index optimizations of 'like' for tree queries. Since the acs_objects table is quaranteed to get quite large in a normal openacs installation, using a non-C locale could result in the system being unusable due to the lack of index support for tree queries.
