Re: rebellious pg stats collector (reopened case) - Mailing list pgsql-admin

From Laszlo Nagy
Subject Re: rebellious pg stats collector (reopened case)
Date
Msg-id 494B9E02.5060904@shopzeus.com
Whole thread Raw
In response to Re: rebellious pg stats collector (reopened case)  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-admin
> It was 78816 and you traced 78815?  Are you sure the process with 24h of
> CPU was pgstat?
>
I'm sorry that was a typo. Of course I traced the good process (proof is
that at the end it renamed a file to "global/pgstat.stat".

And yes, "top" showed 24H in the TIME column and 99% in the WCPU column.
Also this process used 50-90% of disk I/O continuously, slowing down the
computer.

I'm sure that it will happen again, then I'm going to post another trace
(and make sure that I trace the good process).

Best,

   Laszlo



pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: rebellious pg stats collector (reopened case)
Next
From: "Mark Steben"
Date:
Subject: Re: Warm Standby - log shipping