>
> The cpu utilization increases to nearly 100%, in user space, and stays
> there, until the database is restarted.
>
> postgres 1323 47.1 2.3 6667212 6087388 ? Rs 00:00 276:00 \_
postgres: bitbucket bitbucket 172.17.10.1(5114) SELECT
I see you have long-query logging enabled, what was th
Hi Bill,
On 13 June 2014 20:35, Bill Moran wrote:
> On Fri, 13 Jun 2014 20:02:01 +0100 Jaco Engelbrecht
> wrote:
>>
>> This coincides with a checkpoint:
>
> There's a lot going on here (as always with a busy server) but I suspected
> a checkpoint problem earlier, and this statement and your add
On Fri, Jun 13, 2014 at 1:02 PM, Jaco Engelbrecht
wrote:
> hi Scott,
>
> On 13 June 2014 00:30, Scott Marlowe wrote:
>> Just the db and not the server right? Have you tried killing any
>> individual queries that seem to be problem / long running queries?
>
> We have tried to kill individual queri
On Fri, 13 Jun 2014 20:02:01 +0100 Jaco Engelbrecht
wrote:
>
> This coincides with a checkpoint:
There's a lot going on here (as always with a busy server) but I suspected
a checkpoint problem earlier, and this statement and your additional
information makes me suspect even harder.
In your ear
hi Scott,
On 13 June 2014 00:30, Scott Marlowe wrote:
> Just the db and not the server right? Have you tried killing any
> individual queries that seem to be problem / long running queries?
We have tried to kill individual queries before and it did not have any effect.
>> During this performanc
On Thu, Jun 12, 2014 at 1:57 PM, Christopher Nielsen
wrote:
> Lately, though, about once a day now, for about a week, we have been
> experiencing periods of stalling. When Postgres stalls, we haven't been able
> to recover, without restarting the database, unfortunately.
Just the db and not t
On 6/12/2014 12:57 PM, Christopher Nielsen wrote:
With a problem like this, I am not exactly positive how to proceed. I
am really looking forward to hearing your thoughts, and opinions, if
you can share them.
keep a shell session open with a superuser role (eg, postgres), and next
time its
