Re: [Firebird-devel] Firebird 2.5: Performance degradation and increasing file size

[Leyne, S. <Se...@br...>]

> The reason that's interesting is that there is a difference in growth
> between runs - and the runs are identical.  Why would two series have
> exactly the same growth in each run?

That has had me puzzled as well.

By all rights, the free pages created in the first run should be re-used during the second run, and so forth.

The only time that would not be the case, would be if there was a open transaction holding back garbage collection.  But, from Gary's postings, we see that OAT is moving as it should.

It appears that the free pages from the dropped tables are not being re-used.


Sean