Re: 'Index Full Scan' for Index Scan without Index Cond - Mailing list pgsql-patches

From Tom Lane
Subject Re: 'Index Full Scan' for Index Scan without Index Cond
Date
Msg-id 17023.1149604290@sss.pgh.pa.us
Whole thread Raw
In response to Re: 'Index Full Scan' for Index Scan without Index Cond  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: 'Index Full Scan' for Index Scan without Index Cond  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-patches
Simon Riggs <simon@2ndquadrant.com> writes:
> Perhaps we should call it 'Ordered Scan' so that it is completely
> different from 'Index Scan'?

It's not an either/or proposition; the planner could be using the index
for both selectivity and ordering.  This discussion is also overlooking
the possibility that a partial index is being used for its predicate
(again, possibly in combination with explicit index quals and/or
interest in the sort order).

            regards, tom lane

pgsql-patches by date:

Previous
From: Simon Riggs
Date:
Subject: Why do we have a WAL record for CLOG page extension?
Next
From: Tom Lane
Date:
Subject: Re: Why do we have a WAL record for CLOG page extension?