Subbestions: 1) Query timeout 2) Session kill by same login

From: DGPickett <DGPickett(at)aol(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Subbestions: 1) Query timeout 2) Session kill by same login
Date: 2009-03-13 16:03:20
Message-ID: a89ac1dd-de0f-4e68-a0be-2388cd1af684@v19g2000yqn.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I do not see a features suggestion list, so here goes:

I suggest Postgres get these features:

- 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.

- A user session on one login without admin levels of permission
should be able to kill any other session on that login. This way, the
user would not have to bother admin, and if they know they have a
runaway of a session they are no longer connected to, they can take
care of it independently and without waiting for a timeout.

For large projects, and especially when developing or where a
community of users can run their own ad-hoc or user-supplied-parameter-
limited queries, and especailly with new users/developers, excessively
long running queries are a burden to the whole team. These features
would make Postgres and it's clones more suitable for bigger shops,
more scalable.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message DGPickett 2009-03-13 16:05:16 Re: Subbestions: 1) Query timeout 2) Session kill by same login
Previous Message Julio Tavares 2009-03-13 13:43:29 Help with PostgreSql and OID missmatches when restoring database with lobs