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

From: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Partial Indexes Not being Used [WAS]Re: Partial_indexes (Immutable?)
Date: 2008-08-26 06:04:26
Message-ID: 1219730666.9629.32.camel@neuromancer.home.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2008-08-26 at 00:58 -0400, Tom Lane wrote:
> 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

I wouldn't mind if I have a box with a compiler installed or if i have a
NON-Production Box at all.

:-(

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Phoenix Kiula 2008-08-26 06:10:26 Re: Easy upgrade on Cpanel *without* downtime
Previous Message Tom Lane 2008-08-26 04:58:51 Re: Partial Indexes Not being Used [WAS]Re: Partial_indexes (Immutable?)