I'm pretty sure that the mint I've built uses less resources than an ordinary table with transaction logs. We also started thinking about this from the beginning and implemented key rotation, which enables you to drop the db altogether every couple of months or years, after the rotation is finished.

If you like, please join us: https://t.me/CashuBTC