"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
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2005-03-05 04:49:20|
|Subject: Re: BUG #1526: SHRT_MIN out of range on explicit type conversion |
|Previous:||From: Tom Lane||Date: 2005-03-05 04:43:59|
|Subject: Re: BUG #1524: drop view cascade deletes other user's views |