On May 9, 1:49 am, asche.pub...@xxxxxxx (Asche) wrote: > 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 Aah, I understand. Thanks to all for detailed response.
