[horde] IMP VFS tidy up - can ".horde/imp/compose" be safely removed if old?

[SPICY2 MIGRATION ACCOUNT]

After I few tests it seems the old ".horde/imp/compose" VFS entries are
from IMP sessions that have been terminated without sending an email,
as they are cleaned up when the email is sent. So I have backed up the
table and run the following to tidy it up....

delete from horde_vfs where vfs_modified <
unix_timestamp(date_sub(now(), interval 180 day)) and vfs_path =
".horde/imp/compose";


On Sun, 2025-05-11 at 12:58 +1000, SPICY2 MIGRATION ACCOUNT wrote:
> Hi,
> 
> I've noticed the horde_vfs table in an IMP/HORDE instance I help
> manage
> has grown quite large.
> 
> Almost all of the entries in this database have a "vfs_path" of
> ".horde/imp/compose".
> 
> It looks to me these are just temporary VFS entries used during
> message
> composition and can safely be deleted if they are older than, say 3
> months, is this correct?
> 
> I've been looking around and there does not seem to be a lot of info
> how to manage the VFS.
> 
> There is a hint here
> https://horde.horde.narkive.com/h1ekScTE/old-vfs-entries-delete
> that "garbage collection" can be enabled but no mention of how this
> is
> done, and I have searched the FAQ.
> 
> If this is more an IMP question I can post to the IMP list.
> 
> thanks!
> 
> Spicy2
>