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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
