Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] BUG #14714: long running sessions from remote instance seems to hang some times - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] BUG #14714: long running sessions from remote instance seems to hang some times
Date
Msg-id 31737.1497886438@sss.pgh.pa.us
Whole thread Raw
In response to [BUGS] BUG #14714: long running sessions from remote instance seems to hangsome times  (josef.machytka@gmail.com)
List pgsql-bugs
Tree view 
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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [BUGS] BUG #14712: postgres how to handle boolean datatype to use0 and 1 using hibernate
Next
From: Dilip Kumar
Date:
Subject: Re: [BUGS] Postgresql bug report - unexpected behavior of suppress_redundant_updates_trigger