Re: how to limit postgresql process and memory time - Mailing list pgsql-general

From Jan Wieck
Subject Re: how to limit postgresql process and memory time
Date
Msg-id 200201171526.g0HFQvB03353@saturn.janwieck.net
Whole thread Raw
In response to how to limit postgresql process and memory time  (Emmanuel SARACCO <esaracco@noos.fr>)
Responses Re: how to limit postgresql process and memory time  (Brent Verner <brent@rcfile.org>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump behaviour changed in 7.1.3?
Next
From: "Thomas F. O'Connell"
Date:
Subject: Re: news.postgresql.org