Re: Tuning 9.3 for 32 GB RAM

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Tuning 9.3 for 32 GB RAM
Date: 2013-11-15 01:24:05
Message-ID: CAB7nPqSjCCv+gg-4YCPS5ipwR2XjF-8WD0_Hyr-o7DpBEa8zmA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Nov 14, 2013 at 10:44 PM, Alexander Farber
<alexander(dot)farber(at)gmail(dot)com> wrote:
> sysctl.conf:
>
> kernel.shmmax=17179869184
> kernel.shmall=4194304
You do not need those settings in sysctl.conf since 9.3 as consumption
of V shared memory has been reduced with this commit:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=b0fc0df9364d2d2d17c0162cf3b8b59f6cb09f67
Regards,
--
Michael

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Amit Langote 2013-11-15 04:08:28 Re: pg_trgm module: no convertion into Trigrams on one side when comparing
Previous Message Tom Lane 2013-11-14 22:43:49 Re: Push predicate down in view containing window function