Re: pg 7.4.rc1, Range query performance

Поиск
Список
Период
Сортировка
От ow
Тема Re: pg 7.4.rc1, Range query performance
Дата
Msg-id 20031111004139.47333.qmail@web21407.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: pg 7.4.rc1, Range query performance  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Ответы Re: pg 7.4.rc1, Range query performance
Список 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 по дате отправления:

Предыдущее
От: ow
Дата:
Сообщение: Re: pg 7.4.rc1, Range query performance
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: pg 7.4.rc1, Range query performance