From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] One I've never seen before: |
Date: | 1999-02-07 14:55:22 |
Message-ID: | Pine.BSF.4.05.9902071054540.368-100000@thelab.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter T Mount | 1999-02-07 14:57:18 | Re: [HACKERS] Problems with >2GB tables on Linux 2.0 |
Previous Message | Jan Wieck | 1999-02-07 14:08:41 | Re: [HACKERS] strange behaviour on pooled alloc (fwd) |