Re: Linux Kernel setting

BRAHMA PRAKASH TIWARI <prakash_dba@xxxxxxxxxxx> · Fri, 3 Aug 2018 15:58:14 +0000

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

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@xxxxxxxxxxxxxxxx>

Sent: Friday, August 3, 2018 7:31 PM

To: pgsql-admin@xxxxxxxxxxxxxx

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