Re: Is there a way to limit CPU usage per user

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org 
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Tony Wasson
> Sent: 10 February 2006 15:31
> To: Michael Fuhr
> Cc: Luki Rustianto; Merlin Moncure; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Is there a way to limit CPU usage per user
> 
> I may get flamed for this, but this is how I have killed errant
> processes.   I suspect you should pause for a long time before try to
> install plperlu.
> 
> CREATE FUNCTION kill_pid(INTEGER) RETURNS TEXT AS
> $BODY$
>   my ($pid) = @_;
>   my $out=system("kill -TERM $pid");
>   return $out;
> $BODY$ language plperlu;
> 
> REVOKE ALL ON FUNCTION kill_pid(INTEGER) FROM public;

Why not use pg_cancel_backend(pid) - (aside from it sending a SIGINT
rather than TERM)?

Regards, Dave.