On Thursday 08 May 2008, Rauan Maemirov <rauan1987(at)gmail(dot)com> wrote:
> Hi, all. I want to ask what type of index is better to create for
> bigint types. I have table with bigint (bigserial) primary key. What
> type is better to use for it? I tried btree and hash, but didn't
> notice any differences in execution time.
A primary key is a unique btree index, and it's as about as good as it gets
for a bigint.
--
Alan