Search Postgresql Archives

Re: limiting resources to users

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Gauthier, Dave wrote:

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.


on Solaris 10, I'd manage that with zones, running different instances in different zones... you'd also want to segregate the priority database on a separate raid volume to remove IO contention.






--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux