Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group