Automated maintenance tasks on storage backends?

[timwoj]

This was a comment brought up the context of the SQLite backend, but I think it applies to all backends. Should there be a way for backends to schedule running various maintenance tasks, similar to how expiration works? For SQLite, this could be running the VACUUM command and the wal_checkpoint pragmas. Or should this be pushed down to the backends themselves to schedule?