|
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? Thanks. -dave |
