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