slow server : s_lock and _bt_checkkeys on perf top

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

Responses

Browse pgsql-performance by date

  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