On Tue, Aug 27, 2013 at 12:32 PM, Leyne, Sean <Sean@...>wrote:

> Ann,
>
> > Without the query (and any procedures it invokes) I can't say for
> certain that
> > you're seeing garbage collection. It does seem odd that the second run
> also
> > involves writes.
>
> If an older transaction was committed between the execution of the 2
> queries, would garbage collection not cleanup the versions for the newly
> committed transactions?
>

Yes, but if I were trying to demonstrate the behavior of a single statement
run twice, I probably
wouldn't do it when there's other stuff going on in the database.

Cheers,

Ann


[Non-text portions of this message have been removed]