Someone has reported to me that VACUUM ANALYZE is causing different
results for the same query. They believe it is caused by merge join.
I tested in both 8.1.X and CVS HEAD and both appear to be affected. SQL
test attached.
--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com
+ If your life is a hard drive, Christ can be your backup. +