postgres hangs? - 04-29-2004 , 02:31 AM
I have pg-server 7.4 running on mdk linux.
Clients are using a php-gtk based application to communicate with db.
I have noticed a very strange behaviour of the postgres server.
Sometimes it "hangs" during the query (the query itself is quite simple
and does not manipulate a lot of data).
The client "freezes" waiting for the server response; and during such
"hang" - I tried to execute some simple query on a server machine using
psql, I had the same result - the server appeared to be executing the
question, but there was no end...
Restarting postgres always helps - but that's not the solution...
mk (AT) totu (DOT) com