sequential scan when using bigint value

From: David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: sequential scan when using bigint value
Date: 2004-03-19 13:21:12
Message-ID: 405AF3C8.1030601@zara.6.isreserved.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message BRINER Cedric 2004-03-19 14:19:00 self referenced table ?
Previous Message Bas Scheffers 2004-03-19 13:03:35 Re: "People near me" query