Re: pg 7.4.rc1, Range query performance

--- Stephan Szabo <sszabo@megazone.bigpanda.com> wrote:
> I'm not sure that AK_abc is the best index for check a range on a and
> single values on b and c.  I'd think that something like an index
> on (b,c,a) would probably be better for this purpose (without doing any
> testing ;) ).

That would not work for us since most of the time users are working with most
recent data, hence column "a" is the first in the index.

Thanks





__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree