Dave Gauthier wrote: > What does Postgres have for managing/controlling user access > to the DB in terms of resource allocation? I remember in > Oracle, you could specify how many server slots were > available for users to share and how much resources they were > allotted. A super-user that needed more resource for heavy > loading (for example) could be given a private slot with more > resources allocated to that slot. > > What I have is a user who has fired off 6 resource intensive > reports that are bogging my DB down. In the meantime, I have > what I would like to identify as a high priority DB loader > process (running as a super user BTW) that is bogged down > trying to load the DB. So the high priority job is just 1 > out of 7 contenders for the DB. I'd like it to be more like > the DB loader gets 50% of the resources while the reports get > 50% altogether. > > Can this be controlled in PG? You can limit the number of concurrent users with the max_connections parameter. You can limit the amount of memory per backend process with the work_mem parameter. That is all you can do, as far as I know. I cannot think of a way to limit CPU consumption or I/O activity. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
