From owner-freebsd-questions@FreeBSD.ORG Wed Dec 5 13:53:47 2007 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 37CB516A419 for ; Wed, 5 Dec 2007 13:53:47 +0000 (UTC) (envelope-from mayday@gmx.net) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by mx1.freebsd.org (Postfix) with SMTP id 8848313C4DB for ; Wed, 5 Dec 2007 13:53:46 +0000 (UTC) (envelope-from mayday@gmx.net) Received: (qmail 6540 invoked by uid 0); 5 Dec 2007 13:27:05 -0000 Received: from 134.2.188.3 by www100.gmx.net with HTTP; Wed, 05 Dec 2007 14:27:05 +0100 (CET) Content-Type: text/plain; charset="us-ascii" Date: Wed, 05 Dec 2007 14:27:05 +0100 From: "Benjamin Sobotta" In-Reply-To: <20071205114619.GA32423@harmless.hu> Message-ID: <20071205132705.143060@gmx.net> MIME-Version: 1.0 References: <20071205114619.GA32423@harmless.hu> To: Gergely CZUCZY , freebsd-questions@freebsd.org X-Authenticated: #431110 X-Flags: 0001 X-Mailer: WWW-Mail 6100 (Global Message Exchange) X-Priority: 3 X-Provags-ID: V01U2FsdGVkX18PnZMY3HMP2eCm6GxXbmhssihHU+L78xeuRZTYT2 h/pvcVmEe/onNLcb01RWoJiHvOrq4WD9WFRg== Content-Transfer-Encoding: 7bit X-GMX-UID: HZVkdNMAPTR+CjGnNzIw1Z85c2tpZIui Cc: Subject: Re: more then 2G shm on RELENG_7 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 05 Dec 2007 13:53:47 -0000 > Hello, > > I'm to test PostgreSQL on a 7-BETA3. The box has 12GB of memory in it, > I've adjusted the sysctls, but postgresql always fails to allocate the > SHM if it's bigger then 2GB. > > How can I make it to allocate more SHM than 2G at once? > > sysctl.conf: > kern.ipc.shmall=1572864 > kern.ipc.shmmax=6442450944 > kern.ipc.semmap=1024 > kern.ipc.shm_use_phys=1 > > /boot/loader.conf: > zfs_load="YES" > vm.kmem_size="1073741824" > vm.kmem_size_max="1073741824" > kern.ipc.semmni=1024 > kern.ipc.semmns=2048 > kern.ipc.semmnu=1024 > > I've also hit a similar issue with qemu, but that wasn't shared memory, > I had just tried to make it allocate more than 2GBs for a single vm, but > that also failed. Still haven't figured out why was that. > > Sincerely, > > Gergely Czuczy > mailto: gergely.czuczy@harmless.hu > > -- > Weenies test. Geniuses solve problems that arise. Hi! I'm not sure if this is helpful, as I dont run FBSD 7 as of yet. Further I'm not very familiar with the topic. But I had a similiar problem with MySQL on 6.2. What helped for me was play with kern.maxdsiz kern.dfldsiz kern.maxssiz in loader.conf. Cheers, Ben