Laurenz Albe <laurenz.albe@xxxxxxxxxxx> 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
