max_worker_processer configuration for DWH databases?

Hi All
I need to configure the psql parameter for the Dataware Warehousing
Database. I have AWS Aurora PostgreSQL 10.11 with 2 nodes (1-RW,1R)
databases.
Here the problem here in production node ( 64GB RAM/8vCPU) and standby node
side ( 32GB RAM/4vCPU).

But as per the postgreSQL nodes says that max_worker_processes should be
same as prod but my standby node configuration lessar than prod.

Please let me know if I can use the same value or different.

https://www.postgresql.org/docs/10/runtime-config-resource.html
[image: image.png]

production standby
db.r5.2xlarge(64GB RAM/8vCPU) db.x5.xlarge (32GB RAM/4vCPU)
S.No. parameter current value expected Value current value expected Value
1 shared_buffers 5474754 16GB 2694408 8GB
2 effective_cache_size 5474754 48GB 2694408 24GB
3 work_mem 131072 605kb 131072 1210KB
4 maintenance_work_mem 1063936 2GB 528384 2GB
5 max_connections 3466 3466 3466 3466
6 checkpoint_completion_target 0.5 0.9 0.5 0.9
7 wal_buffers 2048 16MB 2048 16MB
8 default_statistics_target 256 500 256 500
9 random_page_cost 1 1.1 1 1.1
10 effective_io_concurrency 256 200 256 200
11 min_wal_size 80 4GB 80 4GB
12 max_wal_size 1024 16GB 1024 16GB
13 max_worker_processes 8 4 8 2
14 max_parallel_workers_per_gather 0 2 0 1
15 max_parallel_workers 1 4 1 2

Thanks & Best Wishes,

Ashok

---------------------------------------------------------------------------------------------------------------------

Ashokkumar Mani *(OCP12c/11g/10g/9i, AWS SAA, M103)*

*Dubai** , UAE* *| BLR , INDIA*

M: *+971 54 723 0075 *| *+91 90086 70302 | *WApp :* +91 81975 99922*

W: https://dbatocloudsolution.blogspot.in/
<http://dbatocloudsolution.blogspot.in/> | E: dbatocloud17(at)gmail(dot)com