Skip site navigation (1) Skip section navigation (2)

8.0 collate and index use

From: Richard Greenwood <richard(dot)greenwood(at)gmail(dot)com>
To: pgsql-hackers-win32(at)postgresql(dot)org
Subject: 8.0 collate and index use
Date: 2004-12-22 04:25:45
Message-ID: ae9185aa04122120252e3cd01d@mail.gmail.com (view raw or flat)
Thread:
Lists: 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(dot)greenwood(at)gmail(dot)com
www.greenwoodmap.com

Responses

pgsql-hackers-win32 by date

Next:From: Thomas KellererDate: 2004-12-22 12:12:16
Subject: Re: locales and encodings on Windows
Previous:From: Harald MassaDate: 2004-12-21 13:10:51
Subject: Re: Windows server installation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group