Again. Fixed.
>
> 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
>
>
-- 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,
Pennsylvania19026