Re: Any advice on debugging hanging postgresql-8.1.21 (many postmaster's) - Mailing list pgsql-general

From Alexander Farber
Subject Re: Any advice on debugging hanging postgresql-8.1.21 (many postmaster's)
Date
Msg-id AANLkTimr8W=BAT0w0WxLpiWbQ6hsRZo3-KuuSCixfMKB@mail.gmail.com
Whole thread Raw
In response to Any advice on debugging hanging postgresql-8.1.21 (many postmaster's)  (Alexander Farber <alexander.farber@gmail.com>)
Responses Re: Any advice on debugging hanging postgresql-8.1.21 (many postmaster's)  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Thank you, I've enabled logging,
but couldn't see anything suspicious there.

Also the 60%-120% CPU-eating postmaster
processes are now suddenly gone.

I suspect this is some bug in the
postgresql-server-8.1.21-1.el5_5.1 delivered
with CenOS 5.5/64 bit, because I don't
have many simultaneous users ( < 100)
and not that many queries.

I'll try to upgrade to 8.4.4 as described at
http://www.pgrpms.org/ later. I'm a bit confused
though that they do not support "yum update" anymore
(I think that worked earlier with PGDG....)

Regards
Alex

pgsql-general by date:

Previous
From: Fujii Masao
Date:
Subject: Re: streaming replication question
Next
From: Joshua Tolley
Date:
Subject: Re: How to see what SQL queries are associated with pg_locks?