X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 614FD47622E for ; Mon, 12 May 2003 19:50:58 -0400 (EDT) Received: from web40312.mail.yahoo.com (web40312.mail.yahoo.com [66.218.78.91]) by postgresql.org (Postfix) with SMTP id D17E4476182 for ; Mon, 12 May 2003 19:50:57 -0400 (EDT) Message-ID: <20030512235100.49769.qmail@web40312.mail.yahoo.com> Received: from [216.103.85.15] by web40312.mail.yahoo.com via HTTP; Mon, 12 May 2003 16:51:00 PDT Date: Mon, 12 May 2003 16:51:00 -0700 (PDT) From: csajl Subject: partial index / funxtional idx or bad sql? To: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Spam-Status: No, hits=-5.8 required=5.0 tests=BAYES_10 version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/136 X-Sequence-Number: 1915 greetings. i have a query that is taking a rather long time to execute and have been looking into setting up a partial index to help, although i'm not sure if this is what i want. here is the table: id serial, type_id int, areacode smallint, content text __________________________________ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com