Re: Postmaster processes taking all the CPU

[MC Moisei <mcmoisei@xxxxxxxxxxx>]

Anyone ?

---

From: mcmoisei@xxxxxxxxxxx
To: pgsql-general@xxxxxxxxxxxxxx
Subject: [GENERAL] Postmaster processes taking all the CPU
Date: Fri, 8 Jun 2007 13:23:00 -0500

Hi,

I have this server that I use as db server. It's decent box Ubuntu, 2GB, AMD Barton 2.8Gb L2 2Mb. DB version is 7.4.7 - that version was the only one available at that time. I have it for about 2 years in similar configuration. Lately I've notices that a pack of postmaster(4-22) processes ran by postgres user are taking over almost all the CPU. If I restart or reboot it calms down but picks up again after a while. I do use psqladmin to vaccum the database but I have nothing schedule to run. Data is added on a daily basis and is under 100 records a day.

My plan is to enable all posible logging and take it from there. I checked syslog there is no error there, I know that too many files open can be a problem. I see none of those or similar. Also I don't see any problem into the syslog. I run a web app that has a connection pool of 25 connection and what appears to happen is that those connection are not finishing or they are very, very slow. Too me it looks that they are waiting on something. Is there a way to see what each postmaster runs or do ?

What's the best approach in this case ? Anyone dealt with similar cases, what was the culprit ?


Thanks,
MC