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

From: Doug McNaught <doug(at)wireboard(dot)com>
To: will trillich <will(at)serensoft(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: another "EXPLAIN -- NO INDEX?" question
Date: 2002-02-10 23:11:00
Message-ID: m3heopyltn.fsf@varsoon.denali.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

will trillich <will(at)serensoft(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dean@TMDT 2002-02-10 23:11:25 Re: I found it, I FOUND IT!!
Previous Message will trillich 2002-02-10 23:08:28 Re: I found it, I FOUND IT!!