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
Last activity: Jul 31, 2022, 02:21 PM