"Theo Petersen" <tpetersen(at)ocv(dot)com> writes:
> I have a database (network monitoring data created by OpenNMS) that exhibits
> this behavior:
> 1) I restore the database from a production backup.
> 2) I perform a select that joins four tables, and get 9 rows of output.
> 3) I use the command VACUUM ANALYZE to maintain the database files.
> 4) I perform the same select and get 0 rows of output.
> I've reduced it to those steps to verify the problem.
Perhaps you should offer some details that would allow someone else to
replicate the problem.
regards, tom lane