Re: sysutils/pfstat db size

[Daniel Hartmeier <daniel%benzedrine.cx@localhost>]

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.

Kind regards,
Daniel