Re: [Fwd: Index Advisor] - Mailing list pgsql-hackers

From Kai-Uwe Sattler
Subject Re: [Fwd: Index Advisor]
Date
Msg-id 22D149FC-21CA-47EF-873A-C8522004AA9B@tu-ilmenau.de
Whole thread Raw
In response to Re: [Fwd: Index Advisor]  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
List pgsql-hackers
Am 20.11.2006 um 06:35 schrieb Gurjeet Singh:
> But there is another bug: if there are recommendations like idx
> (a,b,c), idx(a,b) and idx(a) it would be a good idea to create just
> idx(a). I will add this to pg_advise as an optional feature.
>
> I'd say it's a new feature request and not a bug :) But I don't  
> understand why would you want to not build idx(a,b,c) in such a  
> situation? idx(a,b,c) can be useful in places where idx(a,b) or idx 
> (a) is required, but the same can't be said about idx(a) or idx 
> (a,b) being useful where idx(a,b,c) is required!
>
You are right - that's what I actually meant...
Kai




pgsql-hackers by date:

Previous
From: "Gurjeet Singh"
Date:
Subject: Re: [Fwd: Index Advisor]
Next
From:
Date:
Subject: Tsearch + polish ispell + polish locale