Server admin for Clients ?

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