Re: [PERFORM] CPU spikes and transactions

2013-10-15 Thread Tony Kay
On Tue, Oct 15, 2013 at 10:26 AM, Julien Cigar wrote: > > for two reasons: > > - some of the overhead of bgwriter and checkpoints is more or less linear > in the size of shared_buffers, for example it could be possible that a > large quantity of data could be dirty when a checkpoint occurs). > >

Re: [PERFORM] CPU spikes and transactions

2013-10-15 Thread Tony Kay
we manage, I'll get you the stats. Thanks! Tony Tony Kay TeamUnify, LLC TU Corporate Website <http://www.teamunify.com/> TU Facebook <http://www.facebook.com/teamunify> | Free OnDeck Mobile Apps<http://www.teamunify.com/__corp__/ondeck/> On Tue, Oct 15, 2013 at 6:00 A

Re: [PERFORM] CPU spikes and transactions

2013-10-15 Thread Tony Kay
On Mon, Oct 14, 2013 at 4:42 PM, Tomas Vondra wrote: > 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 web

Re: [PERFORM] CPU spikes and transactions

2013-10-14 Thread Tony Kay
transaction blocking other things would drive the CPUs so hard into the ground with user time. Tony Tony Kay TeamUnify, LLC TU Corporate Website <http://www.teamunify.com/> TU Facebook <http://www.facebook.com/teamunify> | Free OnDeck Mobile Apps<http://www.teamunify.com/__corp__/ondec

[PERFORM] CPU spikes and transactions

2013-10-14 Thread Tony Kay
d familiar to anyone, and if so, please advise. Thanks in advance, Tony Kay