On Wed, Mar 4, 2015 at 1:31 PM, Soni M <diptatapa@xxxxxxxxx> wrote: > Hello All, > > Master db size 1.5 TB > All postgres 9.1.13 installed from RHEL package. > It has streaming replica and slony replica to another servers. > > Server performance is slower than usual, before that, there's a big query > got cancelled and then performance get slow. > > No sign of IO wait. > > on sar, it's %user and %system dominate the cpu usage > 01:25:04 PM CPU %user %nice %system %iowait %steal > %idle > Average: all 51.91 0.00 12.03 0.66 0.00 > 35.39 > > on perf top, i saw > 18.93% postgres [.] s_lock > 10.72% postgres [.] _bt_checkkeys > almost always at top. > > I don't have any idea, what's causing it or how to resolve it ? Can you post the entire 'perf top'? do you see (specifically I'm wondering if you are bumping against the RecoveryInProgress s_lock issue). If so, upgrading postgres might be the best way to resolve the issue. merlin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
