The size growth of my Mastodon PostgresSQL databases is pretty constant (these graphs are for my personal single user instance):
https://munin.mastodon.sadiqsaif.com/zombocloud.com/mastodon.zombocloud.com/postgres_size_ALL.html
Probably something to consider for long term scaling. Maybe a separate PostgreSQL only server would be ideal.