Re: sysutils/pfstat db size

[George Georgalis <george%galis.org@localhost>]

On Thu 27 May 2010 at 12:35:27 PM +0200, Daniel Hartmeier wrote:
>On Wed, May 26, 2010 at 05:37:11PM -0700, George Georgalis wrote:
>
>> it would seem 'pfstat -t days:days' doesn't reduce the size of the
>> db, it only frees up rows for new data. So if the db size gets out
>> of hand by not running -t, then -t is used after the fact, the db
>> remains large (though no longer growing).
>> 
>> Is this expected behavior or a bug? Should it be warned in man
>> page? Upstream?
>
>The behavior may depend on the Berkeley DB implementation being
>used, it seems it doesn't promise to free up space on deletion,
>but doesn't offer some housekeeping function for this purpose,
>either. So, I guess, this should be expected :)
>
>I added a warning in the man page, as well as a new command line
>switch (-f) to copy the database into a new file (skipping freed
>rows), which can be used to compact the file size in this case,
>and in case of database corruption.
>
>The new tarball is http://www.benzedrine.cx/pfstat-2.5.tar.gz
>with MD5 0360d823e3a349709cd645e838d53d79.

Thanks, sounds good.

-George