pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: James Pang (chaolpan) <chaolpan@cisco.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: database collation "C" and "C.LATIN1"
Date: Thu, 09 Mar 2023 09:35:49 -0500
Message-ID: <374722.1678372549@sss.pgh.pa.us> (raw)
In-Reply-To: <5a8c87da0b8b61afd6ce12bb5cd37e87227dc7f1.camel@cybertec.at>
References: <PH0PR11MB51911905C6D8C753E98504FCD6B59@PH0PR11MB5191.namprd11.prod.outlook.com>
	<9ba3e513009bada4845128d4db349346d0f956db.camel@cybertec.at>
	<PH0PR11MB51913B337E7AC2F51427B99CD6B59@PH0PR11MB5191.namprd11.prod.outlook.com>
	<5a8c87da0b8b61afd6ce12bb5cd37e87227dc7f1.camel@cybertec.at>

Laurenz Albe <laurenz.albe@cybertec.at> writes:
> On Thu, 2023-03-09 at 08:37 +0000, James Pang (chaolpan) wrote:
>> Both follow  "C"  collate behavior ,right?  

> Right.

There is another difference: "C" is a built-in collation, while
"C.latin1" must have been something that initdb made because
"locale -a" claimed it exists on your platform.  Postgres has
some optimizations built in for "C" (and its equivalent "POSIX")
that will not apply for "C.latin1".  So while they should be
behaviorally the same, "C.latin1" is likely to be slower.

			regards, tom lane





view thread (6+ messages)

Message-ID: <374722.1678372549@sss.pgh.pa.us>
Permalink:  ../374722.1678372549@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/374722.1678372549@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, laurenz.albe@cybertec.at, chaolpan@cisco.com, pgsql-admin@lists.postgresql.org
  Subject: Re: database collation "C" and "C.LATIN1"
  In-Reply-To: <374722.1678372549@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox