Re: Need to increase performance of a query

From: Anne Rosset <arosset(at)collab(dot)net>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: Craig James <craig_james(at)emolecules(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Need to increase performance of a query
Date: 2010-06-10 21:20:15
Message-ID: 4C11570F.9050209@collab.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message David Jarvis 2010-06-11 00:41:51 Re: Analysis Function
Previous Message Joe Conway 2010-06-10 21:06:24 Re: Need to increase performance of a query