Re: Changing SHMMAX - Mailing list pgsql-general

From Torsten Zühlsdorff
Subject Re: Changing SHMMAX
Date
Msg-id iibtc2$k06$1@news.eternal-september.org
Whole thread Raw
In response to Re: Changing SHMMAX  (Florian Weimer <fweimer@bfk.de>)
Responses Re: Changing SHMMAX
List 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.

pgsql-general by date:

Previous
From: Wouter D'Haeseleer
Date:
Subject: Re: Hot-Standby and sequences
Next
From: "Gauthier, Dave"
Date:
Subject: Streaming Rep 101 questions