Re: [PERFORM] One long transaction or multiple short transactions?

2015-10-07 Thread Carlo
>> How many cores do you have on that machine? Test if limiting number of simultaneous feeds, like bringing their number down to half of your normal connections has the same positive effect. << I am told 32 cores on a LINUX VM. The operators have tried limiting the number of threads. They fe

Re: [PERFORM] shared-buffers set to 24GB but the RAM only use 4-5 GB average

2015-10-07 Thread Merlin Moncure
On Wed, Oct 7, 2015 at 5:29 AM, FattahRozzaq wrote: > Response from you all are very precious. > > @Merlin, > I'm misunderstood the question. > Yes, I didn't measure it. I only monitor RAM and CPU using htop (I also use Can you be a little more specific. What values did you look at and how did y

Re: [PERFORM] shared-buffers set to 24GB but the RAM only use 4-5 GB average

2015-10-07 Thread Scott Marlowe
On Wed, Oct 7, 2015 at 4:29 AM, FattahRozzaq wrote: > Response from you all are very precious. > > @Merlin, > I'm misunderstood the question. > Yes, I didn't measure it. I only monitor RAM and CPU using htop (I also use > nmon for disk IO, iftop for the network utilization). > Did 1 connection nee

Re: [PERFORM] shared-buffers set to 24GB but the RAM only use 4-5 GB average

2015-10-07 Thread FattahRozzaq
Response from you all are very precious. @Merlin, I'm misunderstood the question. Yes, I didn't measure it. I only monitor RAM and CPU using htop (I also use nmon for disk IO, iftop for the network utilization). Did 1 connection need 1 core dedicatedly? (I was having 40-80 connections in stable co

Re: [PERFORM] Re: Multi processor server overloads occationally with system process while running postgresql-9.4

2015-10-07 Thread Scott Marlowe
On Tue, Oct 6, 2015 at 11:08 PM, ajaykbs wrote: > I have checked the transparent huge pages and zone reclaim mode and those are > already disabled. > > As a trial and error method, I have reduced the shared buffer size from > 8500MB to 3000MB. > The CPU i/o wait is icreased a little. But the perio