From: Tom Lane <tgl@sss.pgh.pa.us>
To: Laurenz Albe <laurenz.albe@cybertec.at>
cc: Debraj Manna <subharaj.manna@gmail.com>,
        pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Difference between C and en_US.UTF-8 Collate & CType in Postgres
 10.x
In-reply-to: <2637a385ee9b301b503b728fd8b1f41cab3a7e5b.camel@cybertec.at>
References: 
 <CAF6DVKNU0vb4ZeQQ-=agg69QJU3wdjPnMYYrPYY7CKc6iOU7eQ@mail.gmail.com>
 <0f5ad1359ca05bb3e77c346aa012b1df1d8f5429.camel@cybertec.at>
 <CAF6DVKOy4tadA3Acz_qp_44oF442KgSKiKU7KbSnKNRCo-Vp=g@mail.gmail.com>
 <2637a385ee9b301b503b728fd8b1f41cab3a7e5b.camel@cybertec.at>
Comments: In-reply-to Laurenz Albe <laurenz.albe@cybertec.at>
	message dated "Sun, 16 Sep 2018 17:59:19 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <22687.1537115117.1@sss.pgh.pa.us>
Date: Sun, 16 Sep 2018 12:25:17 -0400
Message-ID: <22688.1537115117@sss.pgh.pa.us>
Precedence: bulk

Laurenz Albe <laurenz.albe@cybertec.at> writes:
> Debraj Manna wrote:
>> Will there be any other difference like in terms of index size, etc?

> The size will be the same, just the ordering will be different.

Just to clarify, index sizes might not be *exactly* the same.  Different
ordering rules might lead to different upper-page-split choices as the
index grows, resulting in different amounts of unused space in some index
pages.  It should average out to about the same thing though.

			regards, tom lane