Re: [ADMIN] restriction clause selectivity bad valueu

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Marcio Macedo <marciom(at)conectiva(dot)com(dot)br>
Cc: "Wallingford, Ted" <twallingford(at)indexc(dot)com>, "'pgsql-sql(at)hub(dot)org'" <pgsql-sql(at)hub(dot)org>, "'pgsql-admin(at)hub(dot)org'" <pgsql-admin(at)hub(dot)org>
Subject: Re: [ADMIN] restriction clause selectivity bad valueu
Date: 2000-01-03 17:20:18
Message-ID: 200001031720.MAA16518@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

[Charset ISO-8859-1 unsupported, filtering to ASCII...]
>
> I got an error like this after use alter table to add a column
>
> when I do a select I got this:
>
>
> database=> select * from table where column = 1;
> ERROR: RestrictionClauseSelectivity: bad value 2.452260
>
> but if i do :
> select * from table where column > 1;
> it goes ok.

VACUUM ANALYZE the table. 6.5.* should not have this problem.

--
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-admin by date

  From Date Subject
Next Message Karl DeBisschop 2000-01-03 19:52:35 Is it possible to run multiple postmasters?
Previous Message Bruce Momjian 2000-01-03 17:19:43 Re: [ADMIN] restriction clause selectivity bad value

Browse pgsql-sql by date

  From Date Subject
Next Message Mitch Vincent 2000-01-04 15:04:35 Triggers
Previous Message Bruce Momjian 2000-01-03 17:19:43 Re: [ADMIN] restriction clause selectivity bad value