We are using PostgrSQL 7.3.4 on MAC OS X G5 with Dual prpcessors and
8 GB RAM.
The postgreSQL server is our backend that stores information for a
Every once in a while, we see a process (thread) that processing a
the JBoss server gets timed out. Supposedly JBoss should clean up
after itself when it times out.
But it did not. If we do "kill -9 pid" to get rid of the deserted
process, it bring down the PG database
Is there a way to kill the dead processes/thread without really affect
the PG server?
pgsql-admin by date
|Next:||From: Gaetano Mendola||Date: 2004-09-27 23:07:28|
|Subject: Re: moving pg_xlog|
|Previous:||From: Oleg Bartunov||Date: 2004-09-27 20:35:54|
|Subject: Re: tsearch2 poor performance|