PostgreSQL performance is generally limited by the number of CPU cores and Memory available. It is recommended that the storage backing Postgres be low-latency (SSD) and capable of high throughput.
The following table provides a general guideline for sizing your PostgreSQL instance based on the number of collectors.