Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bnRNT-0005R8-Nu for pgsql-admin@arkaria.postgresql.org; Fri, 23 Sep 2016 14:23:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bnRNT-0001aq-Ah for pgsql-admin@arkaria.postgresql.org; Fri, 23 Sep 2016 14:22:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bnRNS-0001aL-Gk for pgsql-admin@postgresql.org; Fri, 23 Sep 2016 14:22:58 +0000 Received: from forward3o.cmail.yandex.net ([37.9.109.247]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bnRNP-0000An-1Q for pgsql-admin@postgresql.org; Fri, 23 Sep 2016 14:22:57 +0000 Received: from smtp2m.mail.yandex.net (smtp2m.mail.yandex.net [77.88.61.129]) by forward3o.cmail.yandex.net (Yandex) with ESMTP id A47D620666; Fri, 23 Sep 2016 17:22:52 +0300 (MSK) Received: from smtp2m.mail.yandex.net (localhost.localdomain [127.0.0.1]) by smtp2m.mail.yandex.net (Yandex) with ESMTP id EDBEC2300DB4; Fri, 23 Sep 2016 17:22:51 +0300 (MSK) Received: by smtp2m.mail.yandex.net (nwsmtp/Yandex) with ESMTPSA id 82Ag8y7KRr-Mp6Gk74D; Fri, 23 Sep 2016 17:22:51 +0300 (using TLSv1 with cipher ECDHE-RSA-AES128-SHA (128/128 bits)) (Client certificate not present) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=simply.name; s=mail; t=1474640571; bh=+Qf717Zt7EF/42xGN7bTsqdSLmhyzV7LCkCfvOjbkU4=; h=Subject:From:In-Reply-To:Date:Cc:Message-Id:References:To; b=VO0dbnWHVTby5VUPd1Axv2wVU+NWVDWaO99htPgjG74GEDsjMq5p30uSx8wixb6dj ZaRT8ne1EZFTkQqfCq0A4vUSJOUF0omGn5WKHnU0g8xaouRL5NRyTJkBGxvuMQ9Plx IO67nvF0UQO8HujHxSjTVu4RUdDJFL0wGhvBZD1Q= Authentication-Results: smtp2m.mail.yandex.net; dkim=pass header.i=@simply.name X-Yandex-Suid-Status: 1 0,1 0 Subject: Re: Recommended cluster locale (initdb)? Mime-Version: 1.0 (Mac OS X Mail 9.3 \(3124\)) Content-Type: multipart/alternative; boundary="Apple-Mail=_0C546BA6-EED8-4242-A9EE-1DFCBB1FBD1B" From: Vladimir Borodin X-Priority: 3 In-Reply-To: Date: Fri, 23 Sep 2016 17:22:51 +0300 Cc: pgsql-admin@postgresql.org Message-Id: References: To: Jan-Peter Seifert X-Mailer: Apple Mail (2.3124) X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --Apple-Mail=_0C546BA6-EED8-4242-A9EE-1DFCBB1FBD1B Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 > 23 =D1=81=D0=B5=D0=BD=D1=82. 2016 =D0=B3., =D0=B2 17:07, Jan-Peter = Seifert =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0=D0= =BB(=D0=B0): >=20 > Hello, >=20 > I wonder which locale to choose for the PostgreSQL server itself. >=20 > C for performance or a UTF-8 locale for compatibility? >=20 > Especially if there are LATIN1- and UTF-8 databases etc. ... >=20 > I did not find any articles discussing this. >=20 > Could you tell me, please? Locale should be most certainly UTF-8. The thing to doubt is collation, = you can read about it here [1]. [1] https://simply.name/pg-lc-collate.html = >=20 > Thank you very much, >=20 > Peter >=20 >=20 >=20 >=20 >=20 >=20 >=20 > --=20 > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin -- May the force be with you=E2=80=A6 https://simply.name --Apple-Mail=_0C546BA6-EED8-4242-A9EE-1DFCBB1FBD1B Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
23 =D1=81=D0=B5=D0=BD=D1=82. 2016 =D0=B3., =D0=B2 17:07, = Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de> =D0=BD=D0=B0=D0=BF=D0=B8=D1=81= =D0=B0=D0=BB(=D0=B0):

Hello,

I wonder = which locale to choose for the PostgreSQL server itself.
C for performance or a UTF-8 locale for compatibility?

Especially if there are LATIN1- and UTF-8 = databases etc. ...

I did not find any = articles discussing this.

Could you tell = me, please?

Locale should be most certainly UTF-8. The thing = to doubt is collation, you can read about it here [1].



Thank you very much,

Peter







-- =
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes = to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


--
May the force be with you=E2=80=A6

= --Apple-Mail=_0C546BA6-EED8-4242-A9EE-1DFCBB1FBD1B--