Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YGtdY-0001IW-K0 for pgsql-admin@arkaria.postgresql.org; Thu, 29 Jan 2015 18:16:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YGtdX-0006VD-Vh for pgsql-admin@arkaria.postgresql.org; Thu, 29 Jan 2015 18:16:16 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YGtdW-0006Uw-Pj for pgsql-admin@postgresql.org; Thu, 29 Jan 2015 18:16:14 +0000 Received: from p01c11o143.mxlogic.net ([208.65.144.66]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YGtdO-0000cW-KJ for pgsql-admin@postgresql.org; Thu, 29 Jan 2015 18:16:13 +0000 Received: from unknown [192.207.234.194] (EHLO ExHubCas1.TIGR.ORG) by p01c11o143.mxlogic.net(mxl_mta-8.2.0-3) with ESMTP id 6e87ac45.2ae9df82d940.129268.00-498.367851.p01c11o143.mxlogic.net (envelope-from ); Thu, 29 Jan 2015 11:16:06 -0700 (MST) X-MXL-Hash: 54ca78e67f790c6b-cd05ca96b0f41f84e0d4ce30fa14ba2e74303d01 Received: from unknown [192.207.234.194] (EHLO ExHubCas1.TIGR.ORG) by p01c11o143.mxlogic.net(mxl_mta-8.2.0-3) over TLS secured channel with ESMTP id ad87ac45.0.129183.00-337.367458.p01c11o143.mxlogic.net (envelope-from ); Thu, 29 Jan 2015 11:16:02 -0700 (MST) X-MXL-Hash: 54ca78e20080ad38-be761f885b74187df4cffdb14d4cadb0f0bf81f7 Received: from [172.17.133.146] (172.17.133.146) by ExHubCas1.TIGR.ORG (172.17.5.94) with Microsoft SMTP Server id 8.3.389.2; Thu, 29 Jan 2015 13:15:54 -0500 Message-ID: <54CA78DA.4040607@jcvi.org> Date: Thu, 29 Jan 2015 13:15:54 -0500 From: Michael Heaney User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Thunderbird/31.4.0 MIME-Version: 1.0 To: John Scalia , "pgsql-admin@postgresql.org" Subject: Re: hugepage configuration for V.9.4.0 References: <54CA73CE.1050503@gmail.com> In-Reply-To: <54CA73CE.1050503@gmail.com> Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-AnalysisOut: [v=2.1 cv=RI+nHuS+ c=1 sm=1 tr=0 a=w1dbv1SI/ukx7BArlIOzxg==] X-AnalysisOut: [:117 a=w1dbv1SI/ukx7BArlIOzxg==:17 a=qiJVM4anSgoA:10 a=BLc] X-AnalysisOut: [eEmwcHowA:10 a=IkcTkHD0fZMA:10 a=QWZKEEUnAAAA:8 a=HpMKyOHa] X-AnalysisOut: [AAAA:8 a=YlVTAMxIAAAA:8 a=YNv0rlydsVwA:10 a=epTmVMiNAAAA:8] X-AnalysisOut: [ a=qiveJAhLNN6MjlA7NEUA:9 a=QEXdDO2ut3YA:10 a=RW0jjs6y7BEA] X-AnalysisOut: [:10] X-Spam: [F=0.5000000000; CM=0.500; MH=0.500(2015012906); S=0.200(2014051901)] X-MAIL-FROM: X-SOURCE-IP: [192.207.234.194] X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On 1/29/2015 12:54 PM, John Scalia wrote: > I'm certain that I'm no expert for this one, as I've never had to configure this parameter for anything prior, but I continue to get a startup error when I try to use this. The > server is a VM running CentOS 6.5 with 4 Gb allocated to it. When I started setting "huge_pages = on", the server reported: > > %FATAL: could not map anonymous shared memory: Cannot allocate memory > %HINT: this error usually means that PostgreSQL's request for a shared memory segment exceeded available memory, swap space, or huge pages. To reduce the request size (currently > 1124876288 bytes), reduce PostgreSQL's shared memory usage, perhaps by reducing shared_buffers or max_connections. > > ... More good information here: http://www.postgresql.org/docs/9.4/static/kernel-resources.html#LINUX-HUGE-PAGES I don't think huge pages is going to make much of a difference for a 4GB server, though. -- Michael Heaney JCVI -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin