Database Size - How Big Is Too Big?

Is there a target that folks using the native HA db should try to keep their database size under?

I recently migrated from MariaDB, which required me to reduce my purge days significantly. I liked having weeks of data in case I needed to look something up, but I also recognize that having 10+GB db is a bit ridiculous, even if on a dedicated SSD with plenty of storage available.

The bulk of my data is actually coming from energy data produced by an emporiavue2 running esphome. I’ve already excluded several of the sensors from the recorder, but I want to keep the rest.

So, what should the target DB size limit be to maintain solid HA performance?