Prometheus to monitor Postgres databases in production env


We are doing POC to setup Prometheus to monitor our Production Postgres databases, we have around 1000+ Instance cluster in Postgres so wondering if it is best choice to go with prometheus or not.

If yes then how much Server resources are needed.

Secondly, currently using node and postgres exporter to scrap metrics and storing data in prometheus flat files in Prometheus server but want to implement timecaledb to store metrics data.

Please guide us if there is any use case of it which can be followed .