Thread: RestrictionClauseSelectivity

 March 8, 2001

  I have a Postgresql 6.4.2 database.  I added a char(2) field (call it
  'foo') to one of the tables (call it 'table1') using the ALTER TABLE
  command.  When I try this command:

  select * from table1 where foo='1';

  I get the error message:

  ERROR: RestrictionClauseSelectivity: bad value 2.450299

  What does this mean and how do I fix it?

  Two notes:

  1. Doing a select on other fields in table1 work fine, and the added field displays correctly.
  2. I have the same database for Postgresql 6.5.? and I don't get the error
  message.  Upgrading the database with the problem can't be done at the
  moment.

  Regards,

  Mike Anderson

"Michael R. Anderson" <mike@ferrar.wvsc.edu> writes:
>   ERROR: RestrictionClauseSelectivity: bad value 2.450299
>   What does this mean and how do I fix it?

1. VACUUM ANALYZE.

2. Update your database ASAP.  6.4.2 is ancient.

            regards, tom lane