Re: Changing SHMMAX

From: Torsten Zühlsdorff <foo(at)meisterderspiele(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Changing SHMMAX
Date: 2011-02-02 15:31:14
Message-ID: iibtc2$k06$1@news.eternal-september.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Florian Weimer schrieb:

>> Please guide me how to change it permanently and what is the correct
>> value for it.
>> I am going for 8GB .
>
> Usually, you can put these lines
>
> kernel.shmall = 9000000000
> kernel.shmmax = 9000000000
>
> into /etc/sysctl.conf. Run "sysctl -p" to activate them. However,
> this is a bit distribution-specific.

If you're using FreeBSD you even have to restart the machine.

Greetings,
Torsten
--
http://www.dddbl.de - ein Datenbank-Layer, der die Arbeit mit 8
verschiedenen Datenbanksystemen abstrahiert,
Queries von Applikationen trennt und automatisch die Query-Ergebnisse
auswerten kann.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wouter D'Haeseleer 2011-02-02 15:47:58 Re: Hot-Standby and sequences
Previous Message Sergey Zaharchenko 2011-02-02 15:30:00 Re: Query plan optimization: sorting vs. partitioning