Skip site navigation (1) Skip section navigation (2)

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Theo Petersen" <tpetersen(at)ocv(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1527: select retrieves 0 rows after vacuum analyze
Date: 2005-03-05 04:46:28
Message-ID: 14070.1109997988@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"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

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-03-05 04:49:20
Subject: Re: BUG #1526: SHRT_MIN out of range on explicit type conversion
Previous:From: Tom LaneDate: 2005-03-05 04:43:59
Subject: Re: BUG #1524: drop view cascade deletes other user's views

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group