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

Re: rebellious pg stats collector (reopened case)

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Laszlo Nagy <gandalf(at)shopzeus(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: rebellious pg stats collector (reopened case)
Date: 2008-12-19 13:04:46
Message-ID: 20081219130446.GC4278@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-performance
Laszlo Nagy wrote:
> Alvaro Herrera wrote:
>> Laszlo Nagy wrote:
>>   
>>> PostgreSQL 8.3.5, the system is now stable (uptime > 10 days).   
>>> PostgreSQL stats collector uses 100% CPU forever:
>>>     
>>
>> Could you grab a few stack traces from it and post them?  Also possibly
>> useful, leave strace running on the pgstat process for a while and post
>> the output somewhere.
>>   
> Very interesting results. Before I used 'truss' on the process, it was:
>
> 78816 pgsql            1 106    0 22400K  7100K CPU6   6  24.2H 99.02%  
> postgres
>
> After I started "truss -p 78815" the first message I got was:

It was 78816 and you traced 78815?  Are you sure the process with 24h of
CPU was pgstat?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

pgsql-performance by date

Next:From: Laszlo NagyDate: 2008-12-19 13:13:38
Subject: Re: rebellious pg stats collector (reopened case)
Previous:From: Laszlo NagyDate: 2008-12-19 08:54:36
Subject: Re: rebellious pg stats collector (reopened case)

pgsql-admin by date

Next:From: Laszlo NagyDate: 2008-12-19 13:13:38
Subject: Re: rebellious pg stats collector (reopened case)
Previous:From: Laszlo NagyDate: 2008-12-19 08:54:36
Subject: Re: rebellious pg stats collector (reopened case)

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