Re: best way to kill long running query?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: EE2(at)aeroantenna(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: best way to kill long running query?
Date: 2007-03-21 17:51:22
Message-ID: 12558.1174499482@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Bill Eaton" <EE2(at)aeroantenna(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Teodor Sigaev 2007-03-21 18:13:55 Re: to_tsvector in 8.2.3
Previous Message Robert James 2007-03-21 17:48:20 VACUUM ANALYZE