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

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(at)candle(dot)pha(dot)pa(dot)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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
>
>

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026