View Single Post

   
  #1 (permalink)  
Old 05-10-2008, 03:06 PM
Rauan Maemirov
 
Posts: n/a
Default Creating indexes

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. For GiST and GIN there is a
trouble that I must create operator class, so I limited myself to use
btree or hash. But if it's better to use gist or gin, coment are
welcome.
Reply With Quote