Compact only files with free space
There are many times that I wanted to compact only the files in a DB that had free space (so as not to waste time). This is possible manually by performing a free space check on all files and then selecting only the files with free space to compact, but this is tedious when there are a large number of db files.
If this was implemented it would probably need to prompt the user for a free space threshold, above which to compact. For example compacting a 10Gb file to recover 10Kb of free space is a waste of time.
I submitted this as an NFS in 2007 (#46525).
John Munro
