On Mon, 2 Feb 2004, [iso-8859-2] Egyd Csaba wrote:
> Hi All,
> I'm wonder if there is any possibility to kick out automatically stuck in
> queries after say 10 minutes or so?
> I mean some kind of queries which calls eg. buggy functions with dead loops
> or something similar.
> Time to time I face such kind of problems which are solved automatically
> after some hours/days.
>
> Is there any options in config files or other settings to shorten this time?
See the statement_timeout config parameter.
http://www.postgresql.org/docs/7.3/static/runtime-config.html
Kris Jurka