"Jim Starkey" <jas@...> wrote in message
news:42B0499C.2020008@......

> The feature request that sparked this thread was looking for a

solution

> to catch runaway requests from bad programmers. Perhaps other

people

> have different experiences, but while I have known many bad

programmers,

> I have never met a bad programmer who didn't think he was an
> exceptionally clever programmer. So I have to wonder whether a

feature

> designed only for bad programmers will ever get used.

You are right so we have to assume that all programmers are good.
Then, may we separate two different problems:

1. A good user have changed his mind and have wanted to cancel a
query just after he realized a missed join condition.
2. A good admin wants bad users aren't allowed to bring a server down
starting a hard query every second thus letting good users to feel
angry.

Imho, the former problem is practically solvable but I'm not sure
about the latter.

The latter one should employ some resource management/limitation
scheme, taking into account page fetches, CPU time, kW*h of power
consumed, etc per user account. A good idea would be valuation of all
these resources in money units and provide a daily bill to user.

Regards,
Aleksey Karyakin