Prometheus is not intended as durable long term storage, it's fundamentally limited to the size of a machine. You should also design your monitoring be able to tolerate completely losing the data of a Prometheus.
We recommend using another system for long term data, see https://prometheus.io/docs/operating/integrations/#remote-en... for some examples.