View Single Post

   
  #9 (permalink)  
Old 04-12-2008, 04:50 AM
Tom Lane
 
Posts: n/a
Default Re: pg_terminate_backend

Csaba Nagy <nagy@ecircle-ag.com> writes:
> Now wait a minute, is there some risk of lockup if I kill a backend ?
> Cause I do that relatively often (say 20 times a day, when some web
> users time out but their query keeps running). Should I rather not do it
> ?


statement_timeout is your friend.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Reply With Quote