Re: Index not used, performance problem
От | Jord Tanner |
---|---|
Тема | Re: Index not used, performance problem |
Дата | |
Msg-id | 1048957169.7512.33.camel@gecko обсуждение исходный текст |
Ответ на | Re: Index not used, performance problem ("John K. Herreshoff" <jkherr@centurytel.net>) |
Список | pgsql-performance |
# su postgres % export LANG=C % /usr/local/pgsql/bin/initdb blah blah That always works for me! On Sat, 2003-03-29 at 08:49, John K. Herreshoff wrote: > In Linux (Redhat) where, exactly, does one set the LOCALE to C? > > TIA :-) > > John. > > On Saturday 29 March 2003 10:34 am, Andrew Sullivan wrote: > > On Sat, Mar 29, 2003 at 09:47:51PM +0800, Christopher Kings-Lynne wrote: > > > the form 'FOO%', which is what you are doing. However, I believe that > > > PostgreSQL cannot do this if your database encoding is anything other > > > than 'C'. So, if you are using an Austrian encoding, it might not be > > > able to > > > > That is, you need to have had the LOCALE set to 'C' when you did > > initdb. It's not enough to change it afterwards. > > > > A > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly -- Jord Tanner <jord@indygecko.com>
В списке pgsql-performance по дате отправления: