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

Re: Partial Indexes Not being Used [WAS]Re: Partial_indexes (Immutable?)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Partial Indexes Not being Used [WAS]Re: Partial_indexes (Immutable?)
Date: 2008-08-26 04:58:51
Message-ID: 19674.1219726731@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> writes:
> On Mon, 2008-08-25 at 10:18 -0400, Tom Lane wrote: 
>> I suppose code_id is varchar or some such?

> Yep 
> After a few more investigation on the usefulness of the partial indexes,
> I found that, it really isn't all that useful, perhaps some experts can
> shed some light.

I poked at that example a bit more earlier today, and found that 8.3
has a problem that's interfering with optimizing x IN ('y','z') type
clauses when x is varchar.  If you don't mind building a local copy,
see if this patch helps you any:
http://archives.postgresql.org/pgsql-committers/2008-08/msg00254.php

			regards, tom lane

In response to

Responses

pgsql-general by date

Next:From: Ow Mun HengDate: 2008-08-26 06:04:26
Subject: Re: Partial Indexes Not being Used [WAS]Re: Partial_indexes(Immutable?)
Previous:From: Ow Mun HengDate: 2008-08-26 04:40:25
Subject: Partial Indexes Not being Used [WAS]Re: Partial_indexes(Immutable?)

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