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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
