
VPS for PostgreSQL with a Large Amount of Data
I need a VPS for PostgreSQL. The database is currently about 80 GB and continues to grow. The main workload consists of many read operations, plus regular batch queries.
I’m considering 8 CPU cores / 32 GB RAM / 300 GB NVMe.
Among providers, I’m looking at hostpro.com. How important are RAM and IOPS specifically for PostgreSQL? Does it make sense to get more CPU power if the main load is on the disk and the database cache?
0
