Re: Creating indexes

[Asche <asche(dot)public(at)mac(dot)com>]

Hi,

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

http://www.postgresql.org/docs/8.3/static/sql-createtable.html

PostgreSQL automatically creates an index for each unique constraint and primary key constraint to enforce uniqueness. Thus, it is not necessary to create an index explicitly for primary key columns.

type is better to use for it? I tried btree and hash, but didn't

You already have an index on your bigint primary key. I think it is of type btree.

Jan