JoinClauseSelecivity: bad value

Started by Juan Grigeraalmost 27 years ago2 messagesgeneral
Jump to latest
#1Juan Grigera
root@pombero.biophnet.unlp.edu.ar

Hi all,

Can anyone help me find out what's going on with
this: after a join of 2 tables I get
"ERROR: JoinClauseSelectivity: bad value 2.456159"

I have no clue what's going on here. Any
help appreciated (I am using 6.4.2)

#2Bruce Momjian
bruce@momjian.us
In reply to: Juan Grigera (#1)
Re: [GENERAL] JoinClauseSelecivity: bad value

Hi all,

Can anyone help me find out what's going on with
this: after a join of 2 tables I get
"ERROR: JoinClauseSelectivity: bad value 2.456159"

I have no clue what's going on here. Any
help appreciated (I am using 6.4.2)

vacuum analyze the table. You did an alter table add column. This is
fixed in 6.5. I also bet you are alpha.

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