Postgres Pro
Downloads
Home   >   mailing lists

slow server : s_lock and _bt_checkkeys on perf top - Mailing list pgsql-performance

From Soni M
Subject slow server : s_lock and _bt_checkkeys on perf top
Date
Msg-id CAAMgDX=xTxCV0DMTt5VYGus-LO=1n9wNO7RQni0yvWmbVgD-kQ@mail.gmail.com
Whole thread Raw
Responses Re: slow server : s_lock and _bt_checkkeys on perf top  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Re: slow server : s_lock and _bt_checkkeys on perf top  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: Gunnlaugur Thor Briem
Date:
Subject: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
Next
From: Marc Mamin
Date:
Subject: Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT