Postgres Pro
Downloads
Home   >   mailing lists

Re: best way to kill long running query? - Mailing list pgsql-general

From Tom Lane
Subject Re: best way to kill long running query?
Date
Msg-id 12558.1174499482@sss.pgh.pa.us
Whole thread Raw
In response to best way to kill long running query?  ("Bill Eaton" <EE2@aeroantenna.com>)
Responses Re: best way to kill long running query?  ("Bill Eaton" <EE2@aeroantenna.com>)
List pgsql-general
Tree view 
"Bill Eaton" <EE2@aeroantenna.com> writes:
> I want to allow some queries for my users to run for a prescribed period of
> time and kill them if they go over time. Is there a good way to do this?

set statement_timeout perhaps?

            regards, tom lane

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: to_tsvector in 8.2.3
Next
From: Teodor Sigaev
Date:
Subject: Re: to_tsvector in 8.2.3