Re: appropriate indexing

From: Matt Clark <matt(at)ymogen(dot)net>
To: mailreg(at)numerixtechnology(dot)de
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: appropriate indexing
Date: 2004-11-04 22:38:57
Message-ID: 418AAF81.5040108@ymogen.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> - ITEM table will, grow, grow, grow (sold items are not deleted)
> WHERE PRODUCT.SECTION_USED_FK IS NOT NULL AND ITEM.STATUS=1 and
> (ITEM.KIND=2 or ITEM.KIND=3)
>
Partial index on item.status ?

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message al_nunes 2004-11-04 22:42:03 Re: Better Hardware, worst Results
Previous Message Matt Clark 2004-11-04 22:37:06 Re: Restricting Postgres