Re: BUG #1527: select retrieves 0 rows after vacuum analyze

"Theo Petersen" <tpetersen@ocv.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