Re: pg 7.4.rc1, Range query performance - Mailing list pgsql-sql

From ow
Subject Re: pg 7.4.rc1, Range query performance
Date
Msg-id 20031111004139.47333.qmail@web21407.mail.yahoo.com
Whole thread Raw
In response to Re: pg 7.4.rc1, Range query performance  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: pg 7.4.rc1, Range query performance  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-sql
--- 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


pgsql-sql by date:

Previous
From: ow
Date:
Subject: Re: pg 7.4.rc1, Range query performance
Next
From: Bruce Momjian
Date:
Subject: Re: pg 7.4.rc1, Range query performance