From: | BRAHMA PRAKASH TIWARI <prakash_dba(at)hotmail(dot)com> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, Anjul Tyagi <anjul(at)ibosstech-us(dot)com> |
Subject: | Re: Linux Kernel setting |
Date: | 2018-08-03 15:58:14 |
Message-ID: | MA1PR01MB0454E385638278C62D6DCE6985230@MA1PR01MB0454.INDPRD01.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)ibosstech-us(dot)com>
Sent: Friday, August 3, 2018 7:31 PM
To: pgsql-admin(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2018-08-03 18:46:38 | Re: Fwd: Problem with a "complex" upsert |
Previous Message | Ron | 2018-08-03 15:46:06 | Re: PostgreSQL 9.3 - reindex problem |