From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
---|---|
To: | Greg Smith <greg(at)2ndquadrant(dot)com> |
Cc: | Hashimoto Yuya <hill_climb(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: 100% of CPU utilization postgres process |
Date: | 2010-01-27 13:10:13 |
Message-ID: | 20100127131013.GA14294@depesz.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Jan 26, 2010 at 05:12:51PM -0500, Greg Smith wrote:
> Hashimoto Yuya wrote:
> > Judging from the result, I could see that stats collector process
> > caused this unusually high CPU utilization rate.
> > I found similar problem at
> > http://archives.postgresql.org/pgsql-general/2008-06/msg00934.php,
> > although there seemed
> > no clear cause proven nor the statement that it's because of postgres bug.
>
> Right, that thread concluded with
> http://archives.postgresql.org/pgsql-general/2008-06/msg01026.php where
> Tom suggested it looked like a FreeBSD bug on that version. I just poked
> around a bit, and there do seem to have been a number of bugs in their
> poll() implementation in various versions of that OS, so it seems
> reasonable this is just another one of those.
>
> Note sure if Depez is reading this list or not, just added him to the cc
> list here. Herbert, did you ever get anywhere with tracking this issue down?
No. The database was of friend of a friend, and afair they upgraded, and
afterwards they didn't contact me back.
Best regards,
depesz
--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007
From | Date | Subject | |
---|---|---|---|
Next Message | J Scanf | 2010-01-27 13:32:52 | indexes problem |
Previous Message | Pavel Stehule | 2010-01-27 11:55:35 | Re: dynamic crosstab |