Thanks you for the reply. I going to follow your advice.
I have filtered the entiteties following this guide: How to keep your recorder database size under control, which helped my a lot to get the database smaller.
With Home Assistant 2023.4.0 we get a new database format which has the benefit to have* Smaller (deduplication), less disk usage. Maybe this will help me.