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 по дате отправления