DGPickett wrote:
> - Query times could be limited, by login id or class, so they error
> out after N seconds. There could even be two thresholds, one long one
> for the entire query and another, shorter one for time without a row
> delivered or churned. This way, the user would not have to bother
> admin, and if they did not know they had a runaway, it would take care
> of itself. If the user could institute a second, shorter limit, that
> would add to the value of the feature, as the limit could be tailored
> by query. Churn in process when timed out would be rolled back for
> that query only if a transaction is in process. The session and any
> transactions would remain active.
See statement_timeout.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com