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
​​

Reply via email to