Re: [BUGS] BUG #14714: long running sessions from remote instance seems to hang some times

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] BUG #14714: long running sessions from remote instance seems to hang some times
Дата
Msg-id 31737.1497886438@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [BUGS] BUG #14714: long running sessions from remote instance seems to hangsome times  (josef.machytka@gmail.com)
Список pgsql-bugs
Дерево обсуждения 
josef.machytka@gmail.com writes:
> Sometimes some session goes into some kind of "drowsy" state and runs
> incredibly slowly. It causes some very low disk IO and runs like 20x slower
> then usual.

Is it using a lot of CPU time according to ps or vmstat?

> Do you please have any advice what to check or what setting might help?

If it's eating CPU time, try using "perf" to find out where.
        regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [BUGS] BUG #14712: postgres how to handle boolean datatype to use0 and 1 using hibernate
Следующее
От: Dilip Kumar
Дата:
Сообщение: Re: [BUGS] Postgresql bug report - unexpected behavior of suppress_redundant_updates_trigger