From: | Soni M <diptatapa(at)gmail(dot)com> |
---|---|
To: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | slow server : s_lock and _bt_checkkeys on perf top |
Date: | 2015-03-04 19:31:23 |
Message-ID: | CAAMgDX=xTxCV0DMTt5VYGus-LO=1n9wNO7RQni0yvWmbVgD-kQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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 ?
Any answer is very appreciated.
--
Regards,
Soni Maula Harriz
From | Date | Subject | |
---|---|---|---|
Next Message | Marc Mamin | 2015-03-04 20:10:56 | Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT |
Previous Message | Gunnlaugur Thor Briem | 2015-03-04 19:03:12 | EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT |