On Thursday 22 May 2003 09:23, Fabrice Aeschbacher wrote:

>
> I ran the test again during last night, this time with smaller video
> slices: I insert a new video record for each 1MB read from stream.
> Once again, this completely filled up my 20GB disk during the night;
> the "real" total blob size is 1GB.
>
> Below the interesting part of gstat output (when the disk is full):
>
> Oldest transaction 40298
> Oldest active 40299
> Oldest snapshot 40247
> Next transaction 41004
>
> <...>

It looks as if you are either not committing your transaction(s) or you are
using commit retaining. Either of these will prevent garbage collection.


Paul
--
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase