Re: Creating indexes

[Alan Hodgson <ahodgson(at)simkin(dot)ca>]

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

Attachment: signature.asc
Description: This is a digitally signed message part.