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