On 29/11/11 11:21, tamanna madaan wrote: > Hi Craig > > Thanks for your reply . But unfortunately I dont have that process > running right now. I have already killed that process . But I have > seen this problem sometimes on my setup. > It generally happens when the remote system is going slow for some > reason (CPU utilization high etc.) . But whatever is the reason , I > would assume that the query should return with some error or so > in case the system, the query is running on , is rebooted . But it > doesn't return and remain stuck. Moreover, the same query sometimes > hangs even if it is run on local postgres database so I dont think > network issues have any role in that . Please help.
Well, it *really* shouldn't hang locally. To help you further I'll need you to collect the information on the stuck process next time you encounter one and post that as a reply. Maybe with a bit more info we can see what might be going on. -- Craig Ringer