Thread: Resource allocation?

Resource allocation?

From
David Fetter
Date:
Kind people,

I'm not sure where in the docs to start looking for this, but here's
the situation:

I'd like to be able to run large batch-process jobs for caching, but
limit the total resource utilization on them, something like nice(1).
Better still would be some way to put a max on total resources & be
able to allocate from that.

Does PostgreSQL have facilities for such a thing?

Cheers,
D
-- 
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!


Re: Resource allocation?

From
Neil Conway
Date:
On 4-May-04, at 2:18 PM, David Fetter wrote:
> I'd like to be able to run large batch-process jobs for caching, but
> limit the total resource utilization on them, something like nice(1).
> Better still would be some way to put a max on total resources & be
> able to allocate from that.
>
> Does PostgreSQL have facilities for such a thing?

Well, nice(1) does not limit resource allocation, it changes the 
scheduling priority of a process -- ISTM the two features are largely 
orthogonal.

Limits on resource allocation (i.e. essentially quotas, getrlimit() and 
so on) would be cool; some other people have expressed interest in them 
in the past.

Implementing "batch processes" would be trickier: it seems to me that a 
naive implementation would fall prey to priority inversion. It should 
definitely possible to do, though. If you're interested, have at it :-)

-Neil