Your column is a bigint but 123 defaults to type int. Indexes aren't used when there's a type mismatch. Use an explicit cast or quote it:
select * from bigtable where id = 123::bigint;
Or
select * from bigtable where id = '123';
Thanks Corey, both of these do exactly what I need...
Cheers, Mark
-- Mark Harrison Pixar Animation Studios
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
