Laurette Cisneros <laurette(at)nextbus(dot)com> writes:
> This join worked last week and today it gets and error:
> select * from b, d
> where b.address = d.address;
> It now fails with the following error:
> ERROR: join_selectivity: bad value -0.121693
Probably what has changed is the pg_statistic data (VACUUM ANALYZE
results). Please send the results of
select * from pg_stats where tablename = 'b';
select * from pg_stats where tablename = 'd';
regards, tom lane