Postgres Pro
Downloads
Home   >   mailing lists

Re: appropriate indexing - Mailing list pgsql-performance

From Matt Clark
Subject Re: appropriate indexing
Date
Msg-id 418AAF81.5040108@ymogen.net
Whole thread Raw
In response to appropriate indexing  (T E Schmitz <mailreg@numerixtechnology.de>)
List pgsql-performance
Tree view 
> - 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 ?

pgsql-performance by date:

Previous
From: Matt Clark
Date:
Subject: Re: Restricting Postgres
Next
From: al_nunes@atua.com.br
Date:
Subject: Re: Better Hardware, worst Results