From: BRAHMA PRAKASH TIWARI <prakash_dba@hotmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
To: Anjul Tyagi <anjul@ibosstech-us.com>
Subject: Re: Linux Kernel setting
Date: Fri, 3 Aug 2018 15:58:14 +0000
Message-ID: <MA1PR01MB0454E385638278C62D6DCE6985230@MA1PR01MB0454.INDPRD01.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <em36ef1b53-9559-4e44-acb9-88c7b8270b3d@iboss01081>
References: <em36ef1b53-9559-4e44-acb9-88c7b8270b3d@iboss01081>
Use below link for correct kernel tunning -
https://www.postgresql.org/docs/10/static/kernel-resources.html
PostgreSQL: Documentation: 10: 18.4. Managing Kernel Resources<https://www.postgresql.org/docs/10/static/kernel-resources.html;
Name Description Values needed to run one PostgreSQL instance; SHMMAX: Maximum size of shared memory segment (bytes) at least 1kB, but the default is usually much higher
www.postgresql.org
Regards,Brahma
Sr Manager HCS
________________________________
From: Anjul Tyagi <anjul@ibosstech-us.com>
Sent: Friday, August 3, 2018 7:31 PM
To: pgsql-admin@postgresql.org
Subject: Linux Kernel setting
Team,
we are planing to migrate the database from 9.1 to 10.3 version. We have take advise the pgtune portal to figure out the postgreSQL configuration and modify the based on our requirement.
However, can you all please help me to understand, what parameter need to be setup in the kernel side, i am using SLES 15 version with PG 10.3.
Appreciate for your help.
Regards,
Anjul TYAGI
ΓΌ Go Green
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: prakash_dba@hotmail.com, anjul@ibosstech-us.com
Subject: Re: Linux Kernel setting
In-Reply-To: <MA1PR01MB0454E385638278C62D6DCE6985230@MA1PR01MB0454.INDPRD01.PROD.OUTLOOK.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox