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@Yahoo.com #



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