Re: limiting resources to users

Craig Ringer wrote:
> Gauthier, Dave wrote:
>
>> 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.
>

I've tidied up my previous explanation into a wiki page, since it'll
come up again. Your comments and suggestions would be appreciated:

http://wiki.postgresql.org/wiki/Prioritizing_databases_by_separating_into_multiple_clusters

I've also added a general explanation of the issues with prioritizing
users/queries/connections/databases:

http://wiki.postgresql.org/wiki/Priorities

Both pages are very much draft quality. Comments, edits, etc would be
most welcome.

--
Craig Ringer