On May 9, 1:49 am, asche.pub...@mac.com (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.
