Re: Difference between C and en_US.UTF-8 Collate & CType in Postgres 10.x

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