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