Subject | Re: [firebird-support] Oldest snapshot never moves slowing system down dramatically! |
---|---|
Author | Ann Harrison |
Post date | 2011-03-21T15:33:30Z |
On Mon, Mar 21, 2011 at 2:02 AM, robert.gilland
<robert.gilland@...> wrote:
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
collection.
Good luck,
Ann
<robert.gilland@...> wrote:
> I am using Firebird 2.1.3There are (at least) two possible problems. One is that you're monitoring the
>
> 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?
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
collection.
Good luck,
Ann