Postgres Pro
Downloads
Home   >   mailing lists

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

From Joe Conway
Subject Re: Need to increase performance of a query
Date
Msg-id 4C1153D0.5060806@joeconway.com
Whole thread Raw
In response to Re: Need to increase performance of a query  (Anne Rosset <arosset@collab.net>)
Responses Re: Need to increase performance of a query  (Anne Rosset <arosset@collab.net>)
List pgsql-performance
Tree view 
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
Attachment

pgsql-performance by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Need to increase performance of a query
Next
From: Anne Rosset
Date:
Subject: Re: Need to increase performance of a query