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