Re: [HACKERS] One I've never seen before:

You are correct...that appears to have fixed it.  Is this a problem that
should be investigated, or not to worry about?

On Sun, 7 Feb 1999, Bruce Momjian wrote:

> > 
> > ERROR:  RestrictionClauseSelectivity: bad value 163645.593750
> > 
> > The query is:
> > 
> > SELECT p.first_name, p.last_name, t.title, t.rundate, t.app_version,
> > p.email 
> >   FROM sw_password p, tools t 
> >  WHERE p.userid = t.userid 
> >    AND t.category = 'tools' 
> >  ORDER by t.title;
> > 
> > Something wrong with that taht I'm not seeing? :(  
> 
> Rerun vacuum analyze.  Somehow, bad selectivity/disbursion values are
> getting into the system tables.
> 
> -- 
>   Bruce Momjian                        |  http://www.op.net/~candle
>   maillist@candle.pha.pa.us            |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> 

Marc G. Fournier                                
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org