Re: Need to increase performance of a query - Mailing list pgsql-performance

From Anne Rosset
Subject Re: Need to increase performance of a query
Date
Msg-id 4C11570F.9050209@collab.net
Whole thread Raw
In response to Re: Need to increase performance of a query  (Joe Conway <mail@joeconway.com>)
List pgsql-performance
Joe Conway wrote:
> 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
>
>
Yes it does. Thanks a lot!
Anne

pgsql-performance by date:

Previous
From: Joe Conway
Date:
Subject: Re: Need to increase performance of a query
Next
From: David Jarvis
Date:
Subject: Re: Analysis Function