Re: [GENERAL] JoinClauseSelecivity: bad value

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Juan Grigera <root(at)pombero(dot)biophnet(dot)unlp(dot)edu(dot)ar>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] JoinClauseSelecivity: bad value
Date: 1999-07-07 03:49:21
Message-ID: 199907070349.XAA03205@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kane Tao 1999-07-07 03:59:54 Re: [GENERAL] Auto-timeout on all queries
Previous Message Bruce Momjian 1999-07-07 03:25:46 Re: [GENERAL] backend dies suddenly after a lot of error messages