Re: Mixed Locales and Upgrading

Поиск
Список
Период
Сортировка
От Don Seiler
Тема Re: Mixed Locales and Upgrading
Дата
Msg-id CAHJZqBAGHosweYx74sLHbSkguAt=78m+Bg__-SsbV2FBMKFtPQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Mixed Locales and Upgrading  (Don Seiler <don@seiler.us>)
Ответы Re: Mixed Locales and Upgrading
Re: Mixed Locales and Upgrading
Список pgsql-general
Дерево обсуждения
On Mon, Mar 30, 2020 at 4:39 PM Don Seiler <don@seiler.us> wrote:
On Mon, Mar 30, 2020 at 4:30 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Don Seiler <don@seiler.us> writes:
> Actually, would I need to re-index on text columns that we know contain
> UUID strings? UUID characters seem to be pretty basic alphanumeric ASCII
> characters.

I think you're all right with respect to those, since they're the
same under any encoding.  It's columns containing non-ASCII characters
that you'd want to worry about reindexing.

Follow-up question, the locale setting on the host would still be set to en_US (as would the postgres and template0 databases). Should I look to change that locale on the system to en_US.UTF-8, or even just for the postgres user that the DB cluster runs as? What are the ramification for doing (or not doing) so?

Don. 

--
Don Seiler
www.seiler.us

В списке pgsql-general по дате отправления:

Предыдущее
От: Josef Šimánek
Дата:
Сообщение: Re: Estimated resources for a 500 connections instance (VM)
Следующее
От: "Andrus"
Дата:
Сообщение: Performance degradation if query returns no rows and column expression is used after upgrading to 12