Re: [GENERAL] Terminate query on page exit

2013-02-19 Thread Pavel Stehule
2013/2/19 Jeff Janes : > On Tue, Feb 19, 2013 at 4:38 AM, Pavel Stehule > wrote: >> 2013/2/19 patrick keshishian : >>> On Tuesday, February 19, 2013, Albe Laurenz wrote: One crude method would be to set statement_timeout to a nonzero value - then queries that take longer than

Re: [GENERAL] Terminate query on page exit

2013-02-19 Thread Jeff Janes
On Tue, Feb 19, 2013 at 4:38 AM, Pavel Stehule wrote: > 2013/2/19 patrick keshishian : >> On Tuesday, February 19, 2013, Albe Laurenz wrote: >>> >>> >>> One crude method would be to set statement_timeout to a nonzero >>> value - then queries that take longer than that many seconds >>> will be canc

Re: [GENERAL] Terminate query on page exit

2013-02-19 Thread Albe Laurenz
patrick keshishian wrote: >>> 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? :)

Re: [GENERAL] Terminate query on page exit

2013-02-19 Thread Pavel Stehule
2013/2/19 patrick keshishian : > 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 m

Re: [GENERAL] Terminate query on page exit

2013-02-19 Thread patrick keshishian
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 hea

Re: [GENERAL] Terminate query on page exit

2013-02-19 Thread Albe Laurenz
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

[GENERAL] Terminate query on page exit

2013-02-19 Thread david harel
Greetings, 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 impressio