Josh Berkus <[email protected]> writes:
> Not as far as I can tell. It looks to me like the planner is assuming
> that a forwards index scan and a reverse index scan will have the same
> cost.
Right, because they do. If you think otherwise, demonstrate it.
(bonnie tests approximating a reverse seqscan are not relevant
to the performance of indexscans.)
regards, tom lane
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance