On Thursday 08 May 2008, Rauan Maemirov <[EMAIL PROTECTED]> 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
signature.asc
Description: This is a digitally signed message part.