Subject Re: [firebird-support] garbage collection aspects
Author Dmitry Yemanov
Ann W. Harrison wrote:
>> 3.
>> Now I am doing some test about speed between FB 1.5.2 and FB 2.0.3 and
>> seems to me, that when I am repeating an action which involves table I
>> spoke about it under point 1 (it's records are deleted and again
>> inserted so garbage is growing in this table ) then FB 2 speed is
>> constantly slowing - more garbage more slow, while under FB 1.5 not.
>> Does anyone have some suggestion about it ?
>
> That I don't know anything about.

FB2 SS performs both cooperative and background GC by default, so the
former one may be the reason of the slowdown. v1.5 just postponed
everything to the GC thread (which is far behind) and go further. Some
tweaks with the configuration option PCPolicy in v2.0 would make them
behaving the same way, I believe.


Dmitry