Subject Re: [firebird-support] Oldest snapshot never moves slowing system down dramatically!
Author Ann Harrison
On Mon, Mar 21, 2011 at 2:02 AM, robert.gilland
<robert.gilland@...> wrote:
> I am using Firebird 2.1.3
> I seem to be doing every thing correctly.
> Start transaction then commit it.
> But the oldest snapshot transaction never moves and after not long the system slows down dramatically what can I do?

There are (at least) two possible problems. One is that you're monitoring the
oldest snapshot with a tool that opens a transaction itself, in which
case your observer is causing the effect. The other is that you're doing a
"commit retaining" which maintains context and therefor blocks garbage

Good luck,