partial index / funxtional idx or bad sql?

From: csajl <csajl(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: partial index / funxtional idx or bad sql?
Date: 2003-05-12 23:51:00
Message-ID: 20030512235100.49769.qmail@web40312.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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

Browse pgsql-performance by date

  From Date Subject
Next Message csajl 2003-05-13 00:07:46 [repost] partial index / funxtional idx or bad sql?
Previous Message Tom Lane 2003-05-12 23:50:24 Re: How are null's stored?