--- Bruce Momjian <pgman@candle.pha.pa.us> wrote:
> Tom Lane wrote:
> > Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > > Sorry there isn't a simple solution.
> >
> > But there is: make an index with the column order (b,c,a).
>
> Oh, yea, right. If he puts the columns he is doing a straight equals
> comparison first, the 'a' comparison will work fine. Great.
>
Yes, I think Stephan Szabo was trying to convince me of something like that for
quite sometime; it was not clear to me then. I'll give it a try.
I still think "CREATE [CLUSTERED] INDEX" (or whatever) is an important feature
and should be implemented in pgSql. Locking large (or huge) tables for
prolonged periods of time may not be acceptable in many setups.
Thanks
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree