Rick Debay wrote:

>
>
> Oldest transaction 1569535
> Oldest active 1569536
> Oldest snapshot 1569533
> Next transaction 1584914
>
> Which has a difference of 15381 between your oldest snapshot and your
> next transaction.

To expand on my previous message ...

The sweep interval triggers a sweep when the statistics suggest that
there may be significant garbage collection to be done. Record versions
created after the "oldest snapshot" are not garage - they're back
versions that could be needed for live transactions however elderly they
may be. Nothing created by a transaction younger than the oldest
snapshot can be garbage collected, so those transactions don't affect
the sweep interval. The sweep interval is the difference between the
oldest "interesting" - which gstat prints as simply "oldest transaction"
and the oldest snapshot.

Regards,


Ann