Re: [PERFORM] Creating indexes

2008-05-08 Thread Rauan Maemirov
On May 9, 1:49 am, [EMAIL PROTECTED] (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

Re: [PERFORM] Creating indexes

2008-05-08 Thread Asche
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 cons

Re: [PERFORM] Creating indexes

2008-05-08 Thread PFC
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 o

Re: [PERFORM] Creating indexes

2008-05-08 Thread Alan Hodgson
On Thursday 08 May 2008, Rauan Maemirov <[EMAIL PROTECTED]> wrote: > 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 i

[PERFORM] Creating indexes

2008-05-08 Thread Rauan Maemirov
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 op