Josh Berkus <j...@agliodbs.com> 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 (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
