limiting execution time of queries

[Hagen Hoepfner]

Dear list,

i want to limit the execution time of an SQL-query. That means, that the
query should be stoped if it takes longer that e.g. 10 seconds. How can
I do so?

Hagen

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Bruce Momjian]

Hagen Hoepfner wrote:

Dear list,

i want to limit the execution time of an SQL-query. That means, that the
query should be stoped if it takes longer that e.g. 10 seconds. How can
I do so?

Sure, use SET statement_timeout or in postgresql.conf.

--
Bruce Momjian | http://candle.pha.pa.us
pg***@candle.pha.pa.us | [phone]
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly