BUG #9552: IndexOnlyScan startup_cost>0, why not equal 0?it's a bug? - Mailing list pgsql-bugs

From digoal@126.com
Subject BUG #9552: IndexOnlyScan startup_cost>0, why not equal 0?it's a bug?
Date
Msg-id 20140313005429.398.2021@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #9552: IndexOnlyScan startup_cost>0, why not equal 0?it's a bug?  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
Re: BUG #9552: IndexOnlyScan startup_cost>0, why not equal 0?it's a bug?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      9552
Logged by:          digoal.zhou
Email address:      digoal@126.com
PostgreSQL version: 9.3.3
Operating system:   CentOS 6.4 x64
Description:

I belive index only scan can return tuple direct, it's not need to scan
heappage, why it's startup_cost equal to index scan?
I'ts a bug?

The TEST below:
digoal=# create table t11(id int primary key, info text);
CREATE TABLE
digoal=# insert into t11 select generate_series(1,100000),'test';
INSERT 0 100000
digoal=# explain select * from t11 where id=1;
                             QUERY PLAN
--------------------------------------------------------------------
 Index Scan using t11_pkey on t11  (cost=0.29..4.31 rows=1 width=9)
   Index Cond: (id = 1)
(2 rows)

digoal=# explain select id from t11 where id=1;
                               QUERY PLAN
-------------------------------------------------------------------------
 Index Only Scan using t11_pkey on t11  (cost=0.29..4.31 rows=1 width=4)
   Index Cond: (id = 1)
(2 rows)

pgsql-bugs by date:

Previous
From: jmorton@gmail.com
Date:
Subject: BUG #9551: Hang in State "authentication" Prevents Vacuum from Freeing Dead Rows
Next
From: digoal@126.com
Date:
Subject: BUG #9553: why bitmap index scan startup_cost=0? it's a bug?