Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fleOV-00083L-Aw for pgsql-admin@arkaria.postgresql.org; Fri, 03 Aug 2018 18:01:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fleOT-0003VT-AE for pgsql-admin@arkaria.postgresql.org; Fri, 03 Aug 2018 18:01:41 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1flcTC-0001ML-4A for pgsql-admin@lists.postgresql.org; Fri, 03 Aug 2018 15:58:26 +0000 Received: from mail-oln040092253042.outbound.protection.outlook.com ([40.92.253.42] helo=APC01-SG2-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1flcT7-00035w-Gk for pgsql-admin@postgresql.org; Fri, 03 Aug 2018 15:58:24 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=J7GgvDvIVOMuedS/SzJ09vx1SKcRQtGRu+3th5j45y4=; b=USMXTH3zG9UJNTiPC3mD1GE5t6tC0b/DsgqiOc9zPs8Kw2drlpfnDB3gF20w4SbRRGvLtYVeJ9W2hawU2eUFT83QBWRDdGlYIRhnBujdaxwsWBEjNvt0st7IAeRfmw4FsKm0HqZG4EXcneBc7ucnmYB52O7wzvkJsKhZUbr5Vpp5xX9RYdJBa4d/n3miSCM3f7TP0j3UBWvqFzbU3ch5PjtWzcpY+in72ABHWV+8c8z0jqEbSTFoo31W9Ea/7ZT72oNc3fQlzTP22WbWAmLKJfarY01mbYwQyefpuzNMlfgh+Fa3MP5OMa9jBCzwRbJw2AK1B64dAs1bLm0I25KN0Q== Received: from SG2APC01FT039.eop-APC01.prod.protection.outlook.com (10.152.250.54) by SG2APC01HT202.eop-APC01.prod.protection.outlook.com (10.152.251.66) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.20.995.12; Fri, 3 Aug 2018 15:58:16 +0000 Received: from MA1PR01MB0454.INDPRD01.PROD.OUTLOOK.COM (10.152.250.59) by SG2APC01FT039.mail.protection.outlook.com (10.152.251.12) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.20.1038.3 via Frontend Transport; Fri, 3 Aug 2018 15:58:16 +0000 Received: from MA1PR01MB0454.INDPRD01.PROD.OUTLOOK.COM ([fe80::e892:4860:a849:1b4b]) by MA1PR01MB0454.INDPRD01.PROD.OUTLOOK.COM ([fe80::e892:4860:a849:1b4b%4]) with mapi id 15.20.0995.020; Fri, 3 Aug 2018 15:58:16 +0000 From: BRAHMA PRAKASH TIWARI To: "pgsql-admin@postgresql.org" , Anjul Tyagi Subject: Re: Linux Kernel setting Thread-Topic: Linux Kernel setting Thread-Index: AQHUKzKejfCXcK8sDkq3Bd+6Ifcm5aSuLs/m Date: Fri, 3 Aug 2018 15:58:14 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-incomingtopheadermarker: OriginalChecksum:F83A6BFBF047A9519B92C9D2EEA8034D63F6D75E3E10BE71452ADECE88F6D442;UpperCasedChecksum:ADFD68A1BB58B1656ACE5D4AE20158D9B40A411A8EE611AC50D8355E077778B2;SizeAsReceived:7053;Count:46 x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [AvoWavHdFW992LWUqDMkhI77Uf7fOp1c] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;SG2APC01HT202;6:brvYjwiGD599PSSRXlDhu0ajY2dnpn8onxl9v6ijxRGemnZwMNhpJnEv782xEKcGcYqWFtjGWc5sBnK3TwdkRAbEqG0P0N1nfZjhvPU43/FQLVKmK6+z+d96mFFZwcKwpCMuiqp/t1UvywiqNjRJCcO3mqewYj/rhb9RN2+uKHKi9pGzEEzYtMrl8gYgPiInxe/35IoaQE3tENsh/wkazRXeYN49CXXcCgTAK6BNIwfOckVgvDl4pdTBiZpHWf5VyBB9MmejAsOBEdCi1iiyJRwxCKMfwEaGtDyzemT2yVra2R32g5k5isVJ7AfuvvtorlcJSiMDEvv3Y4AHrm2wIOr3IJy0ewtlw4Xvvglli630b4s7MCb/jEo7hmUEIO3RCR3WMGzQD7Aubz5SPDmJl1qeKMN19xcr5eS9TWopFAJAusPLhExJV8TgHKDwPFomz/oLvmCCP+cI/oW3EYz9qw==;5:RdwGK/eO9A7da9kh7aDDsxe3SUbnBxTUuBqg+x7maNxMjztF8cM4dkqNfmCspW7/rHRBkG8WWClMMffzYVvPcnQWoaJA6YylFUmOFv4HzWBmnzolsz/X5LpAn1jxEydxNb6W5s4ZK+rgr37RhRAPnG2GWcXnL5IhuTb5fUftims=;7:Hc3cx6LWpEw+QUnVxOIsUpkRVYIWytVJw5d2JDhtQfSRlF2mdTgGSyTPjnC3rMCdhFT2bJw+r4WLGlPXsQ77SHGHi2VhcK2OjaQCnlcMRTzNMcXzWJCd4EQuuIjC6pon2LrNCaazY9YJBARVEXCT/VTjZps0ZVOYKek8mC6zHxHkf9yf+fv2/iKi8Y6wRbjhFP6cn2hbVy8sjdliMC+w0EoLse/V/jC8tf/sK61uiugnUkHTggVNydMt7F4yv33I x-incomingheadercount: 46 x-eopattributedmessage: 0 x-microsoft-antispam: BCL:0;PCL:0;RULEID:(7020095)(201702061078)(5061506573)(5061507331)(1603103135)(2017031320274)(2017031322404)(2017031323274)(2017031324274)(1603101475)(1601125500)(1701031045);SRVR:SG2APC01HT202; x-ms-traffictypediagnostic: SG2APC01HT202: x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(4566005)(82015058);SRVR:SG2APC01HT202;BCL:0;PCL:0;RULEID:;SRVR:SG2APC01HT202; x-forefront-prvs: 0753EA505A x-forefront-antispam-report: SFV:NSPM;SFS:(7070007)(53474002)(199004)(189003)(53546011)(26005)(6346003)(6506007)(105586002)(106356001)(966005)(2501003)(2900100001)(11346002)(105004)(102836004)(606006)(446003)(5250100002)(87572001)(76176011)(14454004)(56003)(7696005)(476003)(73972006)(15974865002)(486006)(97736004)(21615005)(19627405001)(256004)(25786009)(83332001)(53346004)(33656002)(104016004)(5660300001)(7116003)(6246003)(86362001)(81156014)(74316002)(20460500001)(6436002)(110136005)(8936002)(8676002)(82202002)(99286004)(229853002)(68736007)(54896002)(6306002)(9686003)(236005)(3480700004)(55016002)(15852004);DIR:OUT;SFP:1901;SCL:1;SRVR:SG2APC01HT202;H:MA1PR01MB0454.INDPRD01.PROD.OUTLOOK.COM;FPR:;SPF:None;PTR:InfoNoRecords;A:1;MX:1; received-spf: None (protection.outlook.com: hotmail.com does not designate permitted sender hosts) authentication-results: spf=none (sender IP is ) smtp.mailfrom=prakash_dba@hotmail.com; x-microsoft-antispam-message-info: rw9/ucHNMv4gKIqvssHAV/Ph7Vi8G5lRZWs8nTzFOrubtQBofynGuY50UZHA0xHyARjK5EXe20kbcfIkAf5mecUEUwKIleOYLQlSGMrFQc1hQbd/2CfsJ1yv7CiTA1jAgaAxmu/zKmvgGdii7tutTA8quEGAMYAfuWN5rIyi/nMa8DWm93HzvY2ct1XvAgX5sO0BCzUCHYurVFLOiXbcKPVj7OYO85KNS9dumFf32Hc= Content-Type: multipart/alternative; boundary="_000_MA1PR01MB0454E385638278C62D6DCE6985230MA1PR01MB0454INDP_" MIME-Version: 1.0 X-OriginatorOrg: hotmail.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: d4d70346-2c10-4f39-8c00-e767963926d9 X-MS-Exchange-CrossTenant-Network-Message-Id: 4a56fe29-d7ec-460c-c185-08d5f959ed13 X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: d4d70346-2c10-4f39-8c00-e767963926d9 X-MS-Exchange-CrossTenant-originalarrivaltime: 03 Aug 2018 15:58:14.1571 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Internet X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-Transport-CrossTenantHeadersStamped: SG2APC01HT202 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_MA1PR01MB0454E385638278C62D6DCE6985230MA1PR01MB0454INDP_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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: Maxi= mum 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 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 ta= ke 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 b= e setup in the kernel side, i am using SLES 15 version with PG 10.3. Appreciate for your help. Regards, Anjul TYAGI =FC Go Green --_000_MA1PR01MB0454E385638278C62D6DCE6985230MA1PR01MB0454INDP_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Use below link for correct kernel tunning -

Name Description Values needed to run one PostgreSQL instance; SHMMAX: Maxi= mum 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 <anj= ul@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 ha= ve 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 1= 0.3.

Appreciate for your help. 

 
 
 

Regards,

Anjul TYAGI

 =

=FC=  Go = ;Green


--_000_MA1PR01MB0454E385638278C62D6DCE6985230MA1PR01MB0454INDP_--