Re: Changing SHMMAX - Mailing list pgsql-general

From Vick Khera
Subject Re: Changing SHMMAX
Date
Msg-id AANLkTinfVnpfZz5wXfXA796TYJbL_-gmbi9XZEr+uqER@mail.gmail.com
Whole thread Raw
In response to Re: Changing SHMMAX  (Torsten Zühlsdorff <foo@meisterderspiele.de>)
List pgsql-general
On Wed, Feb 2, 2011 at 10:31 AM, Torsten Zühlsdorff
<foo@meisterderspiele.de> wrote:
>> 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.
>

No, you do not.  kern.ipc.shmall and shmmax are run-time tunables in FreeBSD.

The only postgres related settings you need a reboot to adjust are
kern.ipc.semmni and semmns.

pgsql-general by date:

Previous
From: Gary Chambers
Date:
Subject: Re: Database Design Question
Next
From: Bill Thoen
Date:
Subject: Why does a normally fast query run so slow when the table is in a partition?