Re: 'Index Full Scan' for Index Scan without Index Cond

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, pgsql-patches(at)postgresql(dot)org
Subject: Re: 'Index Full Scan' for Index Scan without Index Cond
Date: 2006-06-06 14:31:30
Message-ID: 17023.1149604290@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Simon Riggs <simon(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2006-06-06 14:59:59 Re: Why do we have a WAL record for CLOG page extension?
Previous Message Tom Lane 2006-06-06 14:27:53 Re: fillfactor using WITH syntax