There is only one global purge keep days setting.
200MB/day means you will have a 2GB database at the end of the default purge interval (10 days). This is not too bad. Home Assistant can handle that.
I keep 7 days data and while I use excludes extensively it still tops out at about 2.5GB.
Here’s some advice on excluding entities:
You could also shorten the purge keep days and use InfluxDB for long term data storage.
You could also slow your sensor reporting intervals.