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@sss.pgh.pa.us] 
Sent: Wednesday, August 07, 2002 9:46 PM
To: henry@ssc-ltd.com; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] Bug #731: Same SQL produces different results before
and after VACUUM FULL 

pgsql-bugs@postgresql.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