BUG #9552: IndexOnlyScan startup_cost>0, why not equal 0?it's a bug?
| От | digoal@126.com |
|---|---|
| Тема | BUG #9552: IndexOnlyScan startup_cost>0, why not equal 0?it's a bug? |
| Дата | |
| Msg-id | 20140313005429.398.2021@wrigleys.postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #9552: IndexOnlyScan startup_cost>0, why not equal
0?it's a bug?
Re: BUG #9552: IndexOnlyScan startup_cost>0, why not equal 0?it's a bug? |
| Список | 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 по дате отправления: