Re: how to limit postgresql process and memory time

Emmanuel SARACCO wrote:
> hi,
>
> how can I limit all my postgresql processes to a certain percent of
> processor work and a maximum amount of memory.
> for exemple, to limit postgresql to 50% of processor work and 250mo of
> memory.

I don't know of any UNIX operating system that can be
configured that way. You might have to look into some virtual
machine architectures.

Or you can try to get PostgreSQL running on DEC VMS. That OS
does have all these tuning options, real time capabilities,
lots of switches that could be tuned and tuned forever.

> all automatically.

You want something very special, how could that be done
automatically?

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com