At 06:32 PM 11/13/01 -0700, Scott Muir wrote:
>I'm using 7.1 on redhat 7.1...
>
>I had a query result which startled me a bit... it was a simple join and
>the result was like a cartesian product like I hadn't bothered with a when
>clause.
>
>I ran vacuum from inside pgaccess and the results of the query changed to
>what I was expecting in the first place...
AFAIK in most typical cases results should not change because of a vacuum -
performance may change, but the results shouldn't.
If the results change then something is wrong - corrupted/buggy index perhaps.
Cheerio,
Link.