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

From: will trillich <will(at)serensoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: another "EXPLAIN -- NO INDEX?" question
Date: 2002-02-11 00:15:28
Message-ID: 20020210181528.E24785@serensoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Feb 10, 2002 at 06:11:00PM -0500, Doug McNaught wrote:
> will trillich <will(at)serensoft(dot)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(at)hasnolife(dot)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/ ...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message will trillich 2002-02-11 00:29:16 postgresql -- what's in a name?
Previous Message Tom Lane 2002-02-11 00:05:54 Re: another "EXPLAIN -- NO INDEX?" question