Re: Terminate query on page exit

On Tuesday, February 19, 2013, Albe Laurenz wrote:

> david harel wrote:
> > I use postgresql on a Linux server on a virtual machine (despite my
> protest to IT personal).
> > The client is typically a web server implementing PHP sites.
> >
> > Customers many times close a page typically when a heavy report runs for
> too long.
> > Using the command "top", I got the impression that the query still runs
> even though the page was
> > closed.
>
> That is true.
>
> > I want to make sure the query is dropped when the customer closes the
> page.
> > Any method to kill such query would it still hang out there?
>
> One crude method would be to set statement_timeout to a nonzero
> value - then queries that take longer than that many seconds
> will be canceled.


you don't truly mean to advise that, do you? :)
--patrick