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