Re: limiting resources to users

no way for PostgreSQL to have something like Profiles to limite
ressource usage for users?
Is this feature planned for next version? 8-)

Jean-Yves F. Barbier a écrit :
> Gauthier, Dave a écrit :
>
>> Hi:
>>
>>
>>
>> Is there a way in Postgres to limit how much cpu, memory, other
>> resources a certain DB gets?  A MySQL DB that I’m now replacing with PG
>> has been having problems with run-away users that pound one DB with
>> intense processes running periodically in cron jobs.  The effect is that
>> it takes up all the resources and the users of other DBs suffer because
>> the CPU is pegged servicing the first guy..
>>
>>
>>
>> The PG versio will have one PG instance with many DBs.  One set of these
>> DBs are vital for operations and should have the highest priority.
>> Another set of DBs are not vital but their users are the culprits that
>> consume all the resources.  I want to give DBs A, B, and C the highest
>> priority, DBs D, E, F the lowest.  If a DB F user is taking up all the
>> resources, and a DB B users runs a query, I want to service the DB B
>> guys first and backburner the DB F guy until the DB B guy is serviced first.
>>
>
> Buy a chainsaw and cut one hand from each user (Ok --->[])
>
>
> May be you can play with renice (or even with the -N switch in
> start-stop-daemon, but I don't know if it is a regular package
> or just a Debian one).
>
> As nice allow running from -20 to +20 priority, it shall give you
> the pliability you need: as soon as the higher reniced daemon will
> claim power the system will grant him against other process.
>
> JY
>