SELECT waiting

From: Tsirkin Evgeny <tsurkin(at)mail(dot)jct(dot)ac(dot)il>
To: pgsql-admin(at)postgresql(dot)org
Subject: SELECT waiting
Date: 2004-09-06 16:47:53
Message-ID: Pine.LNX.4.58.0409061941320.24709@p-roman.jct.ac.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all!
Another problem :
a web application working under apache2 and using postgresql 7.3.4
is having stack while most of the postmaster proccesses are in state
of SELECT waiting (accroding to ps ax).
after stopping the httpd the postmaster proccesses remains!
that eats a lot of CPU!
and i can see that there are only about 20 httpd connections
reported by netstat .Everything is atack ,the machine is under
very havy load and for nothing !
What can i do?

--
Evgeny.

Browse pgsql-admin by date

  From Date Subject
Next Message NH Lau 2004-09-07 03:33:18 database vacuum
Previous Message Jean-Luc Lachance 2004-09-06 14:36:21 Re: duplicates