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