slow server : s_lock and _bt_checkkeys on perf top

Поиск
Список
Период
Сортировка
От Soni M
Тема slow server : s_lock and _bt_checkkeys on perf top
Дата
Msg-id CAAMgDX=xTxCV0DMTt5VYGus-LO=1n9wNO7RQni0yvWmbVgD-kQ@mail.gmail.com
обсуждение исходный текст
Ответы 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>)
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Gunnlaugur Thor Briem
Дата:
Сообщение: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
Следующее
От: Marc Mamin
Дата:
Сообщение: Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT