Re: Suggest the best values for the postgres configuration parameters

2018-04-11 Thread Laurenz Albe
Raghavendra Rao J S V wrote: > We are using postgres 9.2 version on Centos operating system. That's no good, 9.2 is out of support. Use v10 or at least 9.6. > Total ram available is 80GB . At present we don't have any connection pool > mechanisiam. Max number of connections are allowed is 10

Suggest the best values for the postgres configuration parameters

2018-04-10 Thread Raghavendra Rao J S V
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? - sha