Re: appropriate indexing

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: mailreg@xxxxxxxxxxxxxxxxxxxx
Subject: Re: appropriate indexing
From: Matt Clark <matt@xxxxxxxxxx>
Date: Thu, 04 Nov 2004 22:38:57 +0000
Cc: pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <418AAE19.3030609@xxxxxxxxxxxxxxxxxxxx>
References: <418AAE19.3030609@xxxxxxxxxxxxxxxxxxxx>
User-agent: Mozilla Thunderbird 0.8 (Windows/20040913)

- 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 ?

References:
- appropriate indexing
  - From: T E Schmitz

Prev by Date: Re: Restricting Postgres
Next by Date: Re: Better Hardware, worst Results
Previous by thread: appropriate indexing
Next by thread: Checking = with timestamp field is slow
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux