Skip site navigation (1) Skip section navigation (2)

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

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: 'Index Full Scan' for Index Scan without Index Cond
Date: 2006-06-06 11:19:54
Message-ID: 1149592794.2621.420.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-patches
On Tue, 2006-06-06 at 18:51 +0900, ITAGAKI Takahiro wrote:
> Indexes are used for two purpose, for selection and for ordering, but EXPLAIN
> shows them as 'Index Scan' in both cases. This patch changes EXPLAIN output of
> Index Scan without Index Cond to 'Index Full Scan'.

I like it.

Will that test always hold true? Even if it is currently true, perhaps
there should be a code comment to say we rely on that behaviour later to
make EXPLAIN function correctly? We definitely need some code comments
somewhere.

Perhaps we should call it 'Ordered Scan' so that it is completely
different from 'Index Scan'?

-- 
  Simon Riggs             
  EnterpriseDB   http://www.enterprisedb.com


In response to

Responses

pgsql-patches by date

Next:From: Simon RiggsDate: 2006-06-06 11:54:14
Subject: Re: table/index fillfactor control
Previous:From: Simon RiggsDate: 2006-06-06 11:10:45
Subject: Re: fillfactor using WITH syntax

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group