Creating indexes - Mailing list pgsql-performance

From Rauan Maemirov
Subject Creating indexes
Date
Msg-id 050368ea-4090-4d4e-aef7-b9f2ac06da56@x35g2000hsb.googlegroups.com
Whole thread Raw
Responses Re: Creating indexes
Re: Creating indexes
Re: Creating indexes
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: "Campbell, Lance"
Date:
Subject: Re: Creating a foreign key
Next
From: Alan Hodgson
Date:
Subject: Re: Creating indexes