partial index / funxtional idx or bad sql? - Mailing list pgsql-performance

From csajl
Subject partial index / funxtional idx or bad sql?
Date
Msg-id 20030512235100.49769.qmail@web40312.mail.yahoo.com
Whole thread Raw
List 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


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: How are null's stored?
Next
From: csajl
Date:
Subject: [repost] partial index / funxtional idx or bad sql?