Re: Need to increase performance of a query

From: Joe Conway <mail(at)joeconway(dot)com>
To: Anne Rosset <arosset(at)collab(dot)net>
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:06:24
Message-ID: 4C1153D0.5060806@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Anne Rosset 2010-06-10 21:20:15 Re: Need to increase performance of a query
Previous Message Heikki Linnakangas 2010-06-10 20:59:54 Re: Need to increase performance of a query