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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
