Tom Lane wrote:
This was just covered in excruciating detail yesterday ...
You need to write
order by symbol desc, time desc limit 1
to get the planner to recognize the connection to the sort order
of this index. Since you're only selecting one value of symbol,
the actual output doesn't change.
Is this the right behavior (not a bug)? Is postgresql planning on changing
this soon?
Thanks
Wei
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
