Multi-key indexes

Поиск
Список
Период
Сортировка
От Culley Harrelson
Тема Multi-key indexes
Дата
Msg-id 9aq40k$2v8g$1@news.tht.net
обсуждение исходный текст
Список pgsql-general
Hi, I wanted to verify the behavior of multi-key indexes.  I have this
table:

create table fe_group_member(
 group_id int4 not null references fe_group(group_id) on delete cascade,
 user_id int4 not null references fe_user(user_id) on delete cascade,
 ins_date timestamp not null default 'now',
 primary key(group_id, user_id)
);

Now if I do:

select * from fe_group_member where group_id = 1;

I think the index created by the primary key will be used.  Is this correct?
And if I do:

select * from fe_group_member where user_id= 1;

then the primary key index will not be used and I need to create an index on
user_id for better performance.  Do I have this right?

Culley








В списке pgsql-general по дате отправления:

Предыдущее
От: Joel Burton
Дата:
Сообщение: Re: [DOCS] Better Features document?
Следующее
От: The Hermit Hacker
Дата:
Сообщение: Re: Re: speed on Postgresql compared to Mysql