We are using postgres 9.2 version on Centos operating system.
Total ram available is 80GB . At present we don't have any connection pool mechanisiam. Max number of connections are allowed is 1000.
Could you please suggest the best values for the below configuration parameters?
- shared_buffers
- effective_cache_size
- work_mem
- maintenance_work_mem
- checkpoint_segments
- wal_keep_segments
- checkpoint_completion_target
- Max_prepared_transactions =0
Regards,
Raghavendra Rao J S V
Raghavendra Rao J S V