auto-compaction vs manual compaction

[spastorclovr]

Is this a regression?

No

Description

We have this database on Pika which gets updated every 10mn.
We noticed that it grows out of proportion: up to 10GB while there are only 916442 keys.

I have 2 questions :

• Is this growth "normal". Any ways to prevent it?
• I setup automatic compaction every hour. I can see that we go from 10GB to 5GB. But if I run a manual compaction using the compact command this number goes down to 350MB!. Is there a difference on how auto and manual compaction work?

Thanks a lot!

Version 4.0.2

Please provide a link to a minimal reproduction of the bug

No response

Screenshots or videos

No response

Please provide the version you discovered this bug in (check about page for version information)

Anything else?

No response