Re: [GENERAL] Tunning Server 9.1.

2016-08-04 Thread John R Pierce
On 8/4/2016 2:02 PM, Periko Support wrote: I read some sites on google that it was related to this settings. Can u share your experience on this logs? what you said earlier has nothing to do with what you're saying now. original: I have server that hras increase users and need to increase

Re: [GENERAL] Tunning Server 9.1.

2016-08-04 Thread Patrick B
@John R Pirce, on a 128GB ram system, I would probably have shared_buffers up around 4-8GB. I'm using shared_buffer = 52GB in a 128GB RAM server :O

Re: [GENERAL] Tunning Server 9.1.

2016-08-04 Thread Periko Support
I read some sites on google that it was related to this settings. Can u share your experience on this logs? On Thu, Aug 4, 2016 at 11:17 AM, John R Pierce wrote: > On 8/4/2016 6:01 AM, Periko Support wrote: >> >> This was my message: >> >> PDT FATAL: remaining connection

Re: [GENERAL] Tunning Server 9.1.

2016-08-04 Thread John R Pierce
On 8/4/2016 6:01 AM, Periko Support wrote: This was my message: PDT FATAL: remaining connection slots are reserved for non-replication superuser connections you said you got a message about shared memory ?? thats nothing to do with this ? -- john r pierce, recycling bits in santa

Re: [GENERAL] Tunning Server 9.1.

2016-08-04 Thread Periko Support
This was my message: PDT FATAL: remaining connection slots are reserved for non-replication superuser connections Reading about, some points to max_connections because we have increase users on the network, I tought has sense. In 2 weeks will upgrade to ubuntu 14+psql 9.3 The docs say 25% of

Re: [GENERAL] Tunning Server 9.1.

2016-08-04 Thread John R Pierce
On 8/3/2016 10:13 PM, Periko Support wrote: This send me a message about shared_memory need to lower the value which default settings = 24MB. what message was this, exactly ? on a 128GB ram system, I would probably have shared_buffers up around 4-8GB. btw, postgres 9.1 is getting on in

[GENERAL] Tunning Server 9.1.

2016-08-03 Thread Periko Support
Hi. I have server that hras increase users and need to increase max_connections from default value. Current value = 100 New Value = 200 This send me a message about shared_memory need to lower the value which default settings = 24MB. My server has 128GB in size, for 200 connections what