Re: another "EXPLAIN -- NO INDEX?" question

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: another "EXPLAIN -- NO INDEX?" question
Дата
Msg-id m3heopyltn.fsf@varsoon.denali.to
обсуждение исходный текст
Ответ на Re: another "EXPLAIN -- NO INDEX?" question  (will trillich <will@serensoft.com>)
Ответы Re: another "EXPLAIN -- NO INDEX?" question
Список pgsql-general
will trillich <will@serensoft.com> writes:

> yep -- of the more numerous hits, one overshadows them all:

[...]

> still -- if we're looking for a LOW-FREQUENCY item, wouldn't the
> index seem a reasonable tool to use? i can see that searching
> for 'www.serensoft.com' wouldn't have much (any?) gain from the
> index... but 'dontUthink.com' should, no?

7.1 has pretty primitive statistics; that's why people are suggesting
you upgrade.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

В списке pgsql-general по дате отправления:

Предыдущее
От: will trillich
Дата:
Сообщение: Re: I found it, I FOUND IT!!
Следующее
От: "Dean@TMDT"
Дата:
Сообщение: Re: I found it, I FOUND IT!!