Postgres Pro
Downloads
Home   >   mailing lists

Re: Tuning 9.3 for 32 GB RAM - Mailing list pgsql-general

From Michael Paquier
Subject Re: Tuning 9.3 for 32 GB RAM
Date
Msg-id CAB7nPqSjCCv+gg-4YCPS5ipwR2XjF-8WD0_Hyr-o7DpBEa8zmA@mail.gmail.com
Whole thread Raw
In response to Tuning 9.3 for 32 GB RAM  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Tree view 
On Thu, Nov 14, 2013 at 10:44 PM, Alexander Farber
<alexander.farber@gmail.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Push predicate down in view containing window function
Next
From: Amit Langote
Date:
Subject: Re: pg_trgm module: no convertion into Trigrams on one side when comparing