New answers tagged limits
PostgreSQL thinks it cannot use the index defined on (tank_id, dpg DESC NULLS LAST) to satisfy this query without the sort. If it is just DESC, that is fine. Or if it was just on (tank_id, dpg), that too would work (it would scan the relevant part of the index backwards). If you can't change the definition of the index, then making the query match the ...
Top 50 recent answers are included