sequential scan when using bigint value

Поиск
Список
Период
Сортировка
Искать
От
David Garamond
Тема
sequential scan when using bigint value
Дата
Msg-id
405AF3C8.1030601@zara.6.isreserved.com
Список
Дерево обсуждения
sequential scan when using bigint value David Garamond <lists@zara.6.isreserved.com>
Re: sequential scan when using bigint value Tom Lane <tgl@sss.pgh.pa.us>
Re: sequential scan when using bigint value Bill Moran <wmoran@potentialtech.com>
I have a table of 2mil records. The table consists of two columns, id 
(BYTEA/GUID, PK) and i (INT, UNIQUE INDEX). Could someone explain why, 
when using a bigint value like this:

  select * from partition where i=3000000000;

or

  select * from partition where i in (1,2,3,3000000000);

Postgres immediately switches from index scan to seq scan?

-- 
dave
В списке pgsql-general по дате отправления
От: Bas Scheffers
Дата:
Сообщение: Re: "People near me" query
От: BRINER Cedric
Дата:
Сообщение: self referenced table ?
FAQ