Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YCWW8-0004DW-C7 for pgsql-admin@arkaria.postgresql.org; Sat, 17 Jan 2015 16:46:33 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YCWW7-00005d-S3 for pgsql-admin@arkaria.postgresql.org; Sat, 17 Jan 2015 16:46:31 +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 1YCWW4-00005U-Lg for pgsql-admin@postgresql.org; Sat, 17 Jan 2015 16:46:29 +0000 Received: from nm23-vm5.bullet.mail.ir2.yahoo.com ([212.82.97.20]) by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YCWW1-0001wp-1P for pgsql-admin@postgresql.org; Sat, 17 Jan 2015 16:46:26 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.uk; s=s2048; t=1421513181; bh=x+5Bks06x/Cma4UGow6Ot5GuvO3Z6D8S3yr6hjeaeSA=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=b68eAToaiatlDVsLu+ZTPx+1TV+9iSvzvduq7zpOpnowaOe1Wnbbnlyr2ehrXwJTvASG8QXiPkPMM8nIKQPW0gNedIpurQhSBCESi2KZ9LJGjXsNqz7zYuvy6szo1NGOqVs9fI8TrsrfpU/9MdwivHA0iCtXmTKhuReD7MMC9N2Yl+IsKaoqAIn4maQiEOBgObYcTkjSftsobyjcQhmoeNcUYpMH+7TfDMwJ1wc20lmXX66OzsT4v3wskwS9hRqy586KZReVLSVquCufhpA26l+iYT4q1/5MGSl6xzji+Xmauyneczxk3s89sIbwT+6Y9GLnp0SmziJUfypREsQuiQ== Received: from [212.82.98.125] by nm23.bullet.mail.ir2.yahoo.com with NNFMP; 17 Jan 2015 16:46:21 -0000 Received: from [212.82.98.102] by tm18.bullet.mail.ir2.yahoo.com with NNFMP; 17 Jan 2015 16:46:21 -0000 Received: from [127.0.0.1] by omp1039.mail.ir2.yahoo.com with NNFMP; 17 Jan 2015 16:46:21 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 771079.12955.bm@omp1039.mail.ir2.yahoo.com X-YMail-OSG: Po.hjKoVM1nk_X3hiMSgo0FA0Omze9B2hBcNecnXDOhUPQAKkbQ3xVugBUHffA4 30y5HtzetWEebvOs8mm.3GfWHV7gXqXzG8i8TEUsgHeabYFVYNm2rVmm2sxz0nb7xjvvZVai5fKw evVbOOkSp8oZaGl8ukrCxuDjd.RIYfwdH_8cYdvkjO6FuZigy63a3LJpHQByZLSNBsgLYBPy1h7q KfFqjunNKM4JWISA77acY1n28AIEGlM1UEMbHnuWfgWdAXb1oayfMmV3Ddb2qQPCZZghS9Ij55kN AwZsek8dHsdv6fs550RacOBJrDErTFkpO7_QNmBpsQmqasT5B7k08GUUqZRWPYR9F7Uyi_uCpdkc RYMV.3ianaBF3kbwRSDoL1ek6TnojTOzNMvgPM3186XknUQgOe8LsqH75pr6vRrmsbRPYSVMhgNg Qtv8cuvP.knQbK.6DMjKL48S7d_27tHl5VzQgKGaKG9sTe5Lc5oEhXbWUcPkmna.si2KmRBr47wc- Received: by 217.12.9.10; Sat, 17 Jan 2015 16:46:21 +0000 Date: Sat, 17 Jan 2015 16:46:20 +0000 (UTC) From: Glyn Astill Reply-To: Glyn Astill To: Scott Ribe , Michael Heaney Cc: "pgsql-admin@postgresql.org" Message-ID: <136247579.2784441.1421513180763.JavaMail.yahoo@jws11110.mail.ir2.yahoo.com> In-Reply-To: <2AC05EB2-A9EB-4C5D-A177-C3710AA8BF66@elevated-dev.com> References: <2AC05EB2-A9EB-4C5D-A177-C3710AA8BF66@elevated-dev.com> Subject: Re: Huge pages not working on PG 9.4 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Length: 1129 X-Pg-Spam-Score: -2.0 (--) 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 > From: Scott Ribe > To: Michael Heaney > Cc: "pgsql-admin@postgresql.org" > Sent: Friday, 16 January 2015, 23:39 > Subject: Re: [ADMIN] Huge pages not working on PG 9.4 > > On Jan 16, 2015, at 3:50 PM, Michael Heaney wrote: >> >> Nope, that didn't make any difference. Since I compile my own binary, >> I'm wondering if there's something that 'configure' > didn't set properly. > > Possibly configure needed to see the settings you just made? (I really have > idea--that first link I posted exhausted my knowledge on that subject.) > I've very thin knowledge on this too, but I'll chip in with what I remember. Not sure if you'd have to set hugetlb_shm_group to the gid of the postgres user. And I think you can see what support your kernel was compiled with this: $ grep HUGE /boot/config-$(uname -r) And a quick peek at what you've got set up currently: $ grep -R "" /sys/kernel/mm/hugepages/ /proc/sys/vm/*huge* $ cat /proc/meminfo |grep Huge Perhaps if you post those to the list it'd help someone advise? -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin