Request a Demo
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 8414.1498227263@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] BUG #14714: long running sessions from remote instanceseems to hang some times  (Josef Machytka <josef.machytka@gmail.com>)
Responses Re: [BUGS] BUG #14714: long running sessions from remote instanceseems to hang some times
List pgsql-bugs
Tree view 
Josef Machytka <josef.machytka@gmail.com> writes:
> sorry, here is file with sample - basically several group by aggregations
> over different partitioned tables have been locked in this "drowsy" state

The amount of time being spent in the kernel is strikingly high.  I wonder
if you're seeing some variant of the old "context swap storm" problem.
Try watching the output of "vmstat 1" for awhile to see if the cs rate
is high.
        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: Josef Machytka
Date:
Subject: Re: [BUGS] BUG #14714: long running sessions from remote instanceseems to hang some times
Next
From: "Caio Parolin"
Date:
Subject: [BUGS] RES: Problems installation