Re: Killing "stuck" queries and preventing queries from getting "stuck"

Tim Uckun <timuckun@gmail.com> writes:
> Is there a way to tell postgres to stop any query that runs longer
> than a specified amount of time? Say an hour?

Setting statement_timeout would do that.  You ought to figure out
what's causing the performance problem, though, instead of just
zapping things ...

            regards, tom lane