Measure the working data set
Database size alone does not describe the load. Review which tables and indexes are frequently accessed, how many queries run at once and whether the application needs large temporary results. Start with conservative connection limits and adjust from observed memory and query behaviour.