Re: Need to increase performance of a query

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: Need to increase performance of a query
Дата
Msg-id 4C1153D0.5060806@joeconway.com
обсуждение исходный текст
Ответ на Re: Need to increase performance of a query  (Anne Rosset <arosset@collab.net>)
Ответы Re: Need to increase performance of a query  (Anne Rosset <arosset@collab.net>)
Список pgsql-performance
On 06/10/2010 01:21 PM, Anne Rosset wrote:
>>
> I tried that and it didn't make any difference. Same query plan.

A little experimentation suggests this might work:

create index item_rank_project on item_rank(project_id, rank) where
pf_id IS NULL;

Joe


Вложения

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Need to increase performance of a query
Следующее
От: Anne Rosset
Дата:
Сообщение: Re: Need to increase performance of a query