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

Поиск
Список
Период
Сортировка
От will trillich
Тема Re: another "EXPLAIN -- NO INDEX?" question
Дата
Msg-id 20020210181528.E24785@serensoft.com
обсуждение исходный текст
Ответ на Re: another "EXPLAIN -- NO INDEX?" question  (Doug McNaught <doug@wireboard.com>)
Список pgsql-general
On Sun, Feb 10, 2002 at 06:11:00PM -0500, Doug McNaught wrote:
> will trillich <will@serensoft.com> writes:
> > 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.

ah. and here i thought it was a peer-pressure clique thing. :)

i was hoping it was something i'd been doing wrong...

[any chance at getting 7.2 available as a debian-friendly
potato-happy *.deb?]

--
DEBIAN NEWBIE TIP #57 from Steve Kowalik <stevenk@hasnolife.com>
:
Wondering HOW TO SET YOUR TIME ZONE? Your system clock may be
showing UTC or GMT but you want it to display PDT or whatever.
Just run "tzconfig" as root. (You're sure to have it on your
debian system already -- it's provided in package "libc6".)

Also see http://newbieDoc.sourceForge.net/ ...

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: another "EXPLAIN -- NO INDEX?" question
Следующее
От: will trillich
Дата:
Сообщение: postgresql -- what's in a name?