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!

Tue, 4 May 2004 11:18:48 -0700
David Fetter <david@fetter.org>
Resource allocation?
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


Wed, 5 May 2004 03:39:58 -0400
Neil Conway <neilc@samurai.com>
Re: Resource allocation?