| From: | Vick Khera <vivek(at)khera(dot)org> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Changing SHMMAX |
| Date: | 2011-02-02 20:16:28 |
| Message-ID: | AANLkTinfVnpfZz5wXfXA796TYJbL_-gmbi9XZEr+uqER@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Feb 2, 2011 at 10:31 AM, Torsten Zühlsdorff
<foo(at)meisterderspiele(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Thoen | 2011-02-02 20:17:28 | Why does a normally fast query run so slow when the table is in a partition? |
| Previous Message | Martijn van Oosterhout | 2011-02-02 19:59:18 | Re: Database Design Question |