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 20:13:46
Message-ID: 4C11477A.5020909@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 06/10/2010 01:10 PM, Joe Conway wrote:
> try:
>
> create index item_rank_null_idx on item_rank(pf_id)
> where rank IS NOT NULL AND pf_id IS NULL;

oops -- that probably should be:

create index item_rank_null_idx on item_rank(project_id)
where rank IS NOT NULL AND pf_id IS NULL;

Joe

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2010-06-10 20:15:44 Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?
Previous Message Joe Conway 2010-06-10 20:10:02 Re: Need to increase performance of a query