Re: [PERFORM] CPU spikes and transactions

2013-10-14 Thread Tomas Vondra
On 15.10.2013 01:26, Tony Kay wrote: > Hi Calvin, > > Yes, I have sar data on all systems going back for years. > > Since others are going to probably want to be assured I am really > "reading the data" right: > > - This is 92% user CPU time, 5% sys, and 1% soft > - On some of the problems, I _

Re: [PERFORM] CPU spikes and transactions

2013-10-14 Thread Tomas Vondra
On 15.10.2013 01:00, Tony Kay wrote: > Hi, > > I'm running 9.1.6 w/22GB shared buffers, and 32GB overall RAM on a > 16 Opteron 6276 CPU box. We limit connections to roughly 120, but > our webapp is configured to allocate a thread-local connection, so > those connections are rarely doing anything m

Re: [PERFORM] CPU spikes and transactions

2013-10-14 Thread Tony Kay
Hi Calvin, Yes, I have sar data on all systems going back for years. Since others are going to probably want to be assured I am really "reading the data" right: - This is 92% user CPU time, 5% sys, and 1% soft - On some of the problems, I _do_ see a short spike of pgswpout's (memory pressure), b

[PERFORM] CPU spikes and transactions

2013-10-14 Thread Tony Kay
Hi, I'm running 9.1.6 w/22GB shared buffers, and 32GB overall RAM on a 16 Opteron 6276 CPU box. We limit connections to roughly 120, but our webapp is configured to allocate a thread-local connection, so those connections are rarely doing anything more than half the time. We have been running smo