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