I was facing the same issue i recently implemented these 2 suggestions: https://umh.docs.umh.app/docs/production-guide/administration/reduce-database-size/#retention_sample-1 both retention and compression