| From: | Laszlo Nagy <gandalf(at)shopzeus(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: rebellious pg stats collector (reopened case) |
| Date: | 2008-12-19 13:13:38 |
| Message-ID: | 494B9E02.5060904@shopzeus.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Steben | 2008-12-19 14:14:14 | Re: Warm Standby - log shipping |
| Previous Message | Alvaro Herrera | 2008-12-19 13:04:46 | Re: rebellious pg stats collector (reopened case) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Wong | 2008-12-21 00:54:39 | dbt-2 tuning results with postgresql-8.3.5 |
| Previous Message | Alvaro Herrera | 2008-12-19 13:04:46 | Re: rebellious pg stats collector (reopened case) |