Why sequential scan for currval?

Поиск
Список
Период
Сортировка
Искать
От
John Barham
Тема
Why sequential scan for currval?
Дата
Msg-id
4f34febc0504270028579a6da5@mail.gmail.com
Список
Дерево обсуждения
Why sequential scan for currval? John Barham <jbarham@gmail.com>
Re: Why sequential scan for currval? Klint Gore <kg@kgb.une.edu.au>
Re: Why sequential scan for currval? John Barham <jbarham@gmail.com>
test=# create table tt (id serial unique, s varchar);
[populate tt w/ 100000 rows]
test=# insert into tt (s) values ('foo');
test=# select currval('tt_id_seq');
 currval
---------
  100002
(1 row)
test=# explain select s from tt where id = 100002;
                             QUERY PLAN
---------------------------------------------------------------------
 Index Scan using tt_id_key on tt  (cost=0.00..6.01 rows=1 width=32)
   Index Cond: (id = 100002)
(2 rows)
test=# explain select s from tt where id = currval('tt_id_key');
                      QUERY PLAN
------------------------------------------------------
 Seq Scan on tt  (cost=0.00..1734.42 rows=1 width=32)
   Filter: (id = currval('tt_id_key'::text))
(2 rows)

Why is a sequential scan used when comparing id to currval() value vs.
index scan when compared to a constant?

TIA,

  John
В списке pgsql-general по дате отправления
От: Stephane Bortzmeyer
Дата:
От: John Barham
Дата:
FAQ