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

From Sergey Konoplev
Subject Re: Tuning 9.3 for 32 GB RAM
Date
Msg-id CAL_0b1ussiLe2jFrmit14q0jSXJCGaGvYwuhw6ebNR1sGy4Reg@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
On Thu, Nov 14, 2013 at 5:44 AM, Alexander Farber
<alexander.farber@gmail.com> wrote:
> sysctl.conf:
>
>    kernel.shmmax=17179869184
>    kernel.shmall=4194304

You can also consult this document about kernel and OS settings:

https://github.com/grayhemp/pgcookbook/blob/master/database_server_configuration.md

--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979
gray.ru@gmail.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Mixed locales and date formatting
Next
From: Sergey Konoplev
Date:
Subject: Re: Equivalent syntax of PL/SQL using array in PL/pgSQL