On Fri, Feb 10, 2006 at 11:30:04AM +0700, Luki Rustianto wrote:
> So how can we terminate such a long running query ?
>
> The idea is to make a crontab to periodicaly do a job to search a
> typical "SELECT * FROM bigtable" query who has run for some hours then
> to terminate them...
Are you familiar with the statement_timeout setting?
test=> SET statement_timeout TO 1000; -- milliseconds
SET
test=> SELECT <some long-running query>;
ERROR: canceling statement due to statement timeout
If that won't work then please explain in general terms what problem
you're trying to solve, not how you're trying to solve it.
--
Michael Fuhr