X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B3F4D3A49B0 for ; Thu, 4 Nov 2004 22:41:02 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 54878-05 for ; Thu, 4 Nov 2004 22:40:51 +0000 (GMT) Received: from bayswater1.ymogen.net (host-154-240-27-217.pobox.net.uk [217.27.240.154]) by svr1.postgresql.org (Postfix) with ESMTP id 2E9013A49AA for ; Thu, 4 Nov 2004 22:40:53 +0000 (GMT) Received: from [82.68.132.233] (82-68-132-233.dsl.in-addr.zen.co.uk [82.68.132.233]) by bayswater1.ymogen.net (Postfix) with ESMTP id 65A76A33CB; Thu, 4 Nov 2004 22:40:52 +0000 (GMT) Message-ID: <418AAF81.5040108@ymogen.net> Date: Thu, 04 Nov 2004 22:38:57 +0000 From: Matt Clark User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: mailreg@numerixtechnology.de Cc: pgsql-performance@postgresql.org Subject: Re: appropriate indexing References: <418AAE19.3030609@numerixtechnology.de> In-Reply-To: <418AAE19.3030609@numerixtechnology.de> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200411/69 X-Sequence-Number: 9023 > - 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 ?