Re: another "EXPLAIN -- NO INDEX?" question - Mailing list pgsql-general

From Doug McNaught
Subject Re: another "EXPLAIN -- NO INDEX?" question
Date
Msg-id m3heopyltn.fsf@varsoon.denali.to
Whole thread Raw
In response to Re: another "EXPLAIN -- NO INDEX?" question  (will trillich <will@serensoft.com>)
Responses Re: another "EXPLAIN -- NO INDEX?" question
List 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 by date:

Previous
From: will trillich
Date:
Subject: Re: I found it, I FOUND IT!!
Next
From: "Dean@TMDT"
Date:
Subject: Re: I found it, I FOUND IT!!