[Tom Lane - Wed at 04:33:54PM -0400] > > We have indices on the users_id field and the (users_id, created)-tuple. > > Neither of those indexes can provide the sort order the query is asking > for.
Ah; that's understandable - the planner have two options, to do a index traversion without any extra sorting, or to take out everything and then sort. What I'd like postgres to do is to traverse the index and do some sorting for every unique value of created. Maybe such a feature can be found in future releases - like Postgres 56.3? ;-) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
