[GENERAL] DB encoding, locale and indexes

Hi everyone, I'm a sysadmin working for an application that stores all its data in a PG database. Currently, the cluster has its encoding set to UTF-8, and the locale (both LC_COLLATE and LC_CTYPE) is set to 'en_US.UTF-8'. I discovered recently that the indexes created on varchar fields are not

Re: [GENERAL] DB encoding, locale and indexes

2015-02-05 15:56 GMT+01:00 Tom Lane t...@sss.pgh.pa.us: Sterfield sterfi...@gmail.com writes: I'm a sysadmin working for an application that stores all its data in a PG database. Currently, the cluster has its encoding set to UTF-8, and the locale (both LC_COLLATE and LC_CTYPE) is set

Re: [GENERAL] DB encoding, locale and indexes

Sterfield sterfi...@gmail.com writes: I'm a sysadmin working for an application that stores all its data in a PG database. Currently, the cluster has its encoding set to UTF-8, and the locale (both LC_COLLATE and LC_CTYPE) is set to 'en_US.UTF-8'. I discovered recently that the indexes