Postgres Pro
Downloads
Home   >   mailing lists

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

From Alvaro Herrera
Subject Re: rebellious pg stats collector (reopened case)
Date
Msg-id 20081216134542.GH4741@alvh.no-ip.org
Whole thread Raw
In response to rebellious pg stats collector (reopened case)  (Laszlo Nagy <gandalf@shopzeus.com>)
Responses Re: rebellious pg stats collector (reopened case)  (Laszlo Nagy <gandalf@shopzeus.com>)
List pgsql-admin
Tree view 
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.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-admin by date:

Previous
From: Laszlo Nagy
Date:
Subject: rebellious pg stats collector (reopened case)
Next
From: "Kevin Grittner"
Date:
Subject: Re: How can we see details of function in psql prompt