Skip site navigation (1) Skip section navigation (2)

Re: rebellious pg stats collector (reopened case)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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



In response to

pgsql-performance by date

Next:From: Mark WongDate: 2008-12-21 00:54:39
Subject: dbt-2 tuning results with postgresql-8.3.5
Previous:From: Alvaro HerreraDate: 2008-12-19 13:04:46
Subject: Re: rebellious pg stats collector (reopened case)

pgsql-admin by date

Next:From: Mark StebenDate: 2008-12-19 14:14:14
Subject: Re: Warm Standby - log shipping
Previous:From: Alvaro HerreraDate: 2008-12-19 13:04:46
Subject: Re: rebellious pg stats collector (reopened case)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group