Postgres Professional
   

Re: Shouldn't the planner have a higher cost for reverse index scans?

From: Tom Lane
Subject: Re: Shouldn't the planner have a higher cost for reverse index scans?
Date: ,
Msg-id: 25703.1239383976@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Re: Shouldn't the planner have a higher cost for reverse index scans?  (Josh Berkus)
Responses: Re: Shouldn't the planner have a higher cost for reverse index scans?  (Josh Berkus)
Re: Shouldn't the planner have a higher cost for reverse index scans?  (Matthew Wakeling)
List: pgsql-performance

Tree view

Shouldn't the planner have a higher cost for reverse index scans?  (Josh Berkus, )
 Re: Shouldn't the planner have a higher cost for reverse index scans?  (Tom Lane, )
  Re: Shouldn't the planner have a higher cost for reverse index scans?  (Josh Berkus, )
   Re: Shouldn't the planner have a higher cost for reverse index scans?  (Tom Lane, )
    Re: Shouldn't the planner have a higher cost for reverse index scans?  (Josh Berkus, )
     Re: Shouldn't the planner have a higher cost for reverse index scans?  (Lists, )
      Re: Shouldn't the planner have a higher cost for reverse index scans?  (Grzegorz Jaśkiewicz, )
      Re: Shouldn't the planner have a higher cost for reverse index scans?  (Merlin Moncure, )
       Re: Shouldn't the planner have a higher cost for reverse index scans?  (Tom Lane, )
      Re: Shouldn't the planner have a higher cost for reverse index scans?  (Tom Lane, )
       Re: Shouldn't the planner have a higher cost for reverse index scans?  (Lists, )
        Re: Shouldn't the planner have a higher cost for reverse index scans?  (Tom Lane, )
    Re: Shouldn't the planner have a higher cost for reverse index scans?  (Matthew Wakeling, ) 
Josh Berkus <> 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

pgsql-performance by date:

Previous:
From: Glyn Astill
Date:
Subject: Re: 2.6.26 kernel and PostgreSQL
Next:
From: "M. Edward (Ed) Borasky"
Date:
Subject: Re: Using IOZone to simulate DB access patterns