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 1gBy7v-0004Gm-Cs for pgsql-admin@arkaria.postgresql.org; Mon, 15 Oct 2018 08:21:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gBy7t-0001cv-S1 for pgsql-admin@arkaria.postgresql.org; Mon, 15 Oct 2018 08:21:21 +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 1gBy7t-0001cg-Gz for pgsql-admin@lists.postgresql.org; Mon, 15 Oct 2018 08:21:21 +0000 Received: from mx1.mailbox.org ([2001:67c:2050:104:0:1:25:1]) by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gBy7q-0001Kt-Bz for pgsql-admin@postgresql.org; Mon, 15 Oct 2018 08:21:20 +0000 Received: from smtp1.mailbox.org (unknown [IPv6:2001:67c:2050:105:465:1:1:0]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mx1.mailbox.org (Postfix) with ESMTPS id D22B642920; Mon, 15 Oct 2018 10:21:14 +0200 (CEST) X-Virus-Scanned: amavisd-new at heinlein-support.de Received: from smtp1.mailbox.org ([80.241.60.240]) by spamfilter02.heinlein-hosting.de (spamfilter02.heinlein-hosting.de [80.241.56.116]) (amavisd-new, port 10030) with ESMTP id F-dint6i5nlz; Mon, 15 Oct 2018 10:21:11 +0200 (CEST) Message-ID: <54f17ea619c4a0d74f8ecc71d91d8862162aa5c2.camel@cybertec.at> Subject: Re: How should the correct value of shmmax be calculated for DWH (OLAP) server From: Laurenz Albe To: "Gunnar \"Nick\" Bluth" , "Shukla, Sumeet" , "pgsql-admin@postgresql.org" Date: Mon, 15 Oct 2018 10:21:09 +0200 In-Reply-To: <5BC4466E.7070902@pro-open.de> References: <4647b0c67c2c5d4dc08032f1b11240665711af95.camel@cybertec.at> <5BC4466E.7070902@pro-open.de> Organization: Cybertec Content-Type: text/plain; charset="UTF-8" Mime-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Gunnar "Nick" Bluth wrote: > Am 15.10.2018 um 09:43 schrieb Laurenz Albe: > > Shukla, Sumeet wrote: > >> Can someone please help me determine the appropriate value of kernel shmmax > >> parameter for PostgreSQL configured for Data Warehouse use? > > > > Simple. Set it to anything bigger than your "shared_buffers" setting. > > If PostgreSQL manages to start, your setting is big enough. > > > > As a matter of fact, you shouldn't need to set SHMMAX anyway, unless you > tampered with "dynamic_shared_memory_type" or you are on a very exotic > OS ;-) True, I was living in the past. Thanks for the correction. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com