Re: Bug #731: Same SQL produces different results before and after VACUUM FULL

Dear Tom,

Our Postgresql version is 7.2. We have not upgraded to 7.2.1 yet.

I cannot simulate what happened that time. But however, during that
time, we have also tried the 2 SQL in the attached file but also
produced different results before VACUUM FULL.

(I expect them to produce same result)

However, they produced same result after VACUUM FULL.

I hope this could help your investigation.

Thanks.

Regards,
Henry

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wednesday, August 07, 2002 9:46 PM
To: henry(at)ssc-ltd(dot)com; pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] Bug #731: Same SQL produces different results before
and after VACUUM FULL

pgsql-bugs(at)postgresql(dot)org writes:
> Same SQL produces different results before and after VACUUM FULL

What Postgres version is this?

What does EXPLAIN show for the query plan in each state?

regards, tom lane