key = currval('tab_key_seq') choses SEQSCAN?!

Поиск
Список
Период
Сортировка
От Brandon Craig Rhodes
Тема key = currval('tab_key_seq') choses SEQSCAN?!
Дата
Msg-id vwy8qq3jz0.fsf@guinness.ts.gatech.edu
обсуждение исходный текст
Ответы Re: key = currval('tab_key_seq') choses SEQSCAN?!  (Martin Marques <martin@bugs.unl.edu.ar>)
Re: key = currval('tab_key_seq') choses SEQSCAN?!  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I have a large table (named "changes") which is perfectly willing to
support index lookups when its primary key (named "change") is
compared to a constant integer:

# explain select * from changes where change = 42;
                                 QUERY PLAN
-----------------------------------------------------------------------------
 Index Scan using changes_pkey on changes  (cost=0.00..3.01 rows=1 width=78)
   Index Cond: (change = 42)
(2 rows)

But this same table suddenly becomes unwilling to use an index scan if
the target value is the result of the currval() function:

# explain select * from changes where change = currval('changes_change_seq');
                        QUERY PLAN
----------------------------------------------------------
 Seq Scan on changes  (cost=0.00..323.21 rows=1 width=78)
   Filter: (change = currval('changes_change_seq'::text))
(2 rows)

Explicitly casting the result of currval() to an integer (of any size)
does not seem improve the situation.  Is my expectation unreasonable
that the planner should consider the result of an INTEGER CAST in the
same way it considers a literal integer?

--
Brandon Craig Rhodes                         http://www.rhodesmill.org/brandon
Georgia Tech                                            brandon@oit.gatech.edu

В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: REINDEX issues
Следующее
От: Martin Marques
Дата:
Сообщение: Re: key = currval('tab_key_seq') choses SEQSCAN?!