
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? :(  

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


Sun, 7 Feb 1999 02:24:34 -0400 (AST)
The Hermit Hacker <scrappy@hub.org>
One I've never seen before:

quick appendum to my own...

the 'category' field was created with an 'alter table' command, if that
helps any...

even from psql, it comes back:

postgresql=> select category from tools where category = 'projects';
ERROR:  RestrictionClauseSelectivity: bad value 163645.593750

If I do it without the where clause, or a where cluase on any other field,
all appears well, its only teh one I created with 'alter table' that is
"screwed"...

Neat...if I rename the table to something else, the problem goes away.  If
I rename it to old_tools, it still exists, but if I rename it to software,
the problem disappears...*raised eyebrows*

 and the table looks like:

postgresql=> \d tools

Table    = tools
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| userid                           | text                             |   var |
| title                            | text                             |   var |
| url                              | text                             |   var |
| platform                         | text                             |   var |
| app_version                      | text                             |   var |
| pg_version                       | text                             |   var |
| contact_name                     | text                             |   var |
| contact_email                    | text                             |   var |
| institution                      | text                             |   var |
| company_url                      | text                             |   var |
| keywords                         | text                             |   var |
| description                      | text                             |   var |
| rundate                          | datetime                         |     8 |
| category                         | text                             |   var |
+----------------------------------+----------------------------------+-------+

On Sun, 7 Feb 1999, The Hermit Hacker 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? :(  
> 
> Marc G. Fournier                                
> Systems Administrator @ hub.org 
> primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 
> 
> 

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


Sun, 7 Feb 1999 02:39:18 -0400 (AST)
The Hermit Hacker <scrappy@hub.org>
Re: [HACKERS] One I've never seen before:
> 
> 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

Sun, 7 Feb 1999 07:33:49 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
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 


Sun, 7 Feb 1999 10:55:22 -0400 (AST)
The Hermit Hacker <scrappy@hub.org>
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?
> 

I am worried about it.  My guess is that ALTER TABLE is putting random
date into the attdisbursion column.  I will check on it when I finish
with the optimizer.

-- 
  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

Sun, 7 Feb 1999 15:08:42 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] One I've never seen before:
> 
> quick appendum to my own...
> 
> the 'category' field was created with an 'alter table' command, if that
> helps any...
> 
> even from psql, it comes back:
> 
> postgresql=> select category from tools where category = 'projects';
> ERROR:  RestrictionClauseSelectivity: bad value 163645.593750
> 
> If I do it without the where clause, or a where cluase on any other field,
> all appears well, its only teh one I created with 'alter table' that is
> "screwed"...
> 
> Neat...if I rename the table to something else, the problem goes away.  If
> I rename it to old_tools, it still exists, but if I rename it to software,
> the problem disappears...*raised eyebrows*
> 
>  and the table looks like:

Fixed.  Problem was I was not initializing the new column properly.

-- 
  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

Wed, 24 Feb 1999 12:31:50 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
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@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, Pennsylvania 19026

Wed, 24 Feb 1999 12:32:34 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] One I've never seen before: