Re: limiting resources to users

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
--
There is no sincerer love than the love of food.
-- George Bernard Shaw