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

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

Previous
From: Tom Lane
Date:
Subject: Re: another "EXPLAIN -- NO INDEX?" question
Next
From: will trillich
Date:
Subject: postgresql -- what's in a name?