Sample Header Ad - 728x90

AWS RDS Postgresql and max_worker_processes

0 votes
1 answer
2804 views
AWS RDS Postgresql 12.10 According to https://www.enterprisedb.com/postgres-tutorials/comprehensive-guide-how-tune-database-parameters-and-configuration-postgresql , > max_worker_processes **Set this to the number of CPUs you want to share > for PostgreSQL exclusively**. This is the number of background processes > the database engine can use. Setting this parameter will require a > server restart. **The default is 8.** The default is also 8 in AWS RDS Postgresql, no matter the Instance type (and thus number of vCPUs). Am I cheating myself by paying for a db.r5.12xlarge (48 CPUs) while using the default max_worker_processes value?
Asked by RonJohn (694 rep)
Jul 30, 2022, 03:52 PM
Last activity: Jul 31, 2022, 02:21 PM