How to manage database size?

Hi all,

The page Managing your database’s size talks about various ways to archive or purge data from the database. When does it make sense to start archiving old data?

How large is the typical Matomo database? How many months (or years) of data are typically in the database?

Has anyone looked into how the server resources required to run Matomo change as the database grows in size or as the number of visits tracked per day increases?