Creating indexes

Поиск
Список
Период
Сортировка
От Rauan Maemirov
Тема Creating indexes
Дата
Msg-id 050368ea-4090-4d4e-aef7-b9f2ac06da56@x35g2000hsb.googlegroups.com
обсуждение исходный текст
Ответы Re: Creating indexes  (Alan Hodgson <ahodgson@simkin.ca>)
Re: Creating indexes  (Asche <asche.public@mac.com>)
Re: Creating indexes  (PFC <lists@peufeu.com>)
Список 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 по дате отправления:

Предыдущее
От: "Campbell, Lance"
Дата:
Сообщение: Re: Creating a foreign key
Следующее
От: Alan Hodgson
Дата:
Сообщение: Re: Creating indexes