pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
SELECT waiting 3+ messages / 3 participants [nested] [flat]
* SELECT waiting @ 2004-09-06 16:47 Tsirkin Evgeny <tsurkin@mail.jct.ac.il> 0 siblings, 0 replies; 3+ messages in thread From: Tsirkin Evgeny @ 2004-09-06 16:47 UTC (permalink / raw) To: 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. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Select waiting @ 2005-11-18 11:07 Armel HERVE <aherve@programshop.com> 0 siblings, 0 replies; 3+ messages in thread From: Armel HERVE @ 2005-11-18 11:07 UTC (permalink / raw) To: pgsql-admin Hello there, when I have connections waiting, can I kill the root connection which is the origin of the lock, without restarting the postgres server ? I know it's not a good practice, but we are in a developpement step... Thanks for your answers (adn sorry for my poor english :-) ) -- Armel HERVE ProgramShop Direction Technique 04 95 04 57 32 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Select waiting @ 2005-11-18 11:13 Armel HERVE <ah.pgsql@laposte.net> 0 siblings, 0 replies; 3+ messages in thread From: Armel HERVE @ 2005-11-18 11:13 UTC (permalink / raw) To: pgsql-admin Hello there, when I have connections waiting, can I kill the root connection which is the origin of the lock, without restarting the postgres server ? I know it's not a good practice, but we are in a development step... Thanks for your answers (and sorry for my poor English :-) ) Armel ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-11-18 11:13 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-09-06 16:47 SELECT waiting Tsirkin Evgeny <tsurkin@mail.jct.ac.il> 2005-11-18 11:07 Select waiting Armel HERVE <aherve@programshop.com> 2005-11-18 11:13 Select waiting Armel HERVE <ah.pgsql@laposte.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox