From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "Gauthier, Dave *EXTERN*" <dave(dot)gauthier(at)intel(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Server admin for Clients ? |
Date: | 2009-06-08 09:22:10 |
Message-ID: | D960CB61B694CF459DCFB4B0128514C202FF6632@exadv11.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jordi Martínez | 2009-06-08 09:30:17 | PL/PGSQL |
Previous Message | Albe Laurenz | 2009-06-08 09:18:42 | Re: trigger functions with arguments |