8.0 collate and index use
От | Richard Greenwood |
---|---|
Тема | 8.0 collate and index use |
Дата | |
Msg-id | ae9185aa04122120252e3cd01d@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: 8.0 collate and index use
|
Список | pgsql-hackers-win32 |
My apologies if this has already been discussed ad infinitium... I built and installed postgresql on windows2000, initdb w/o any options, and noticed that my indexes were not being used in instance where they were being used on my linux postgresql installation (same database, tables, and indexes). The queries where indexes were not being used on the windows system were LIKE on varchar fileds. On my linux system: pg_controldata LC_COLLATE: C LC_TYPE: C on my windows system: pg_controldata LC_COLLATE: English_United States.1252 LC_CTYPE: English_United States.1252 I figure the index non-use issue is due to collate and/or ctype, so I: initdb --locale=C --lc-collate=C and indexes are now being used as expected. Did I address it in the best manner? Did I overlook anything that should have been obvious? Should a new windows postgres user be expected to spot this and address it? Thanks for reading. Best regards, -- Richard Greenwood richard.greenwood@gmail.com www.greenwoodmap.com
В списке pgsql-hackers-win32 по дате отправления: