postgres hangs?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Michal Kuna

    postgres hangs?

    Hi all,

    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...

    Please help

    --
    Michal Kuna
    [email protected]
Working...