David Rowley <dgrowleyml@xxxxxxxxx> writes: > On Thu, 24 Jun 2021 at 10:55, Alvaro Herrera <alvherre@xxxxxxxxxxxxxx> wrote: >> It is not relevant from the partitioning point of view. Other factors >> can be used to decide the column order. > I'm not so sure that's really 100% true. There is at least one > partitioning feature that will work when the partitioning column is > first and won't when it's not. > Ordered partition scans work with RANGE and LIST partitioning: Sure, but is that any different from the behavior with unpartitioned tables? You have to make the index column order agree with the ORDER BY you want to use, in either case. regards, tom lane
