pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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