SELECT waiting - Mailing list pgsql-admin

From Tsirkin Evgeny
Subject SELECT waiting
Date
Msg-id Pine.LNX.4.58.0409061941320.24709@p-roman.jct.ac.il
Whole thread Raw
List 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.

pgsql-admin by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Re: duplicates
Next
From: NH Lau
Date:
Subject: database vacuum