From owner-freebsd-questions@FreeBSD.ORG Mon Nov 5 08:25:47 2012 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 5B39A977 for ; Mon, 5 Nov 2012 08:25:47 +0000 (UTC) (envelope-from brfr@metrico.lu) Received: from design18.letzebuerg.net (design18.letzebuerg.net [5.9.44.110]) by mx1.freebsd.org (Postfix) with ESMTP id D2F2C8FC0A for ; Mon, 5 Nov 2012 08:25:46 +0000 (UTC) Received: from [88.207.233.58] (port=59827 helo=[192.168.0.6]) by design18.letzebuerg.net with esmtpsa (TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.80) (envelope-from ) id 1TVH7S-000e3n-Ne for freebsd-questions@freebsd.org; Mon, 05 Nov 2012 08:29:14 +0100 Message-ID: <50976AC9.1010402@metrico.lu> Date: Mon, 05 Nov 2012 08:29:13 +0100 From: Frank Broniewski User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:16.0) Gecko/20121028 Thunderbird/16.0.2 MIME-Version: 1.0 To: freebsd-questions@freebsd.org Subject: Re: Why PostgreSQL doesn't start with shared_buffers=6GB ? References: <50970E35.6000600@rawbw.com> In-Reply-To: <50970E35.6000600@rawbw.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - design18.letzebuerg.net X-AntiAbuse: Original Domain - freebsd.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - metrico.lu X-Get-Message-Sender-Via: design18.letzebuerg.net: authenticated_id: brfr@metrico.lu X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 05 Nov 2012 08:25:47 -0000 Hi, I'm running Postgresql 9.1 on FreeBSD 9.0 with the following settings: # postgresql.conf shared_buffers = 8GB # pgtune wizard 2012-04-04 # /boot/loader.conf kern.ipc.semmni=256 kern.ipc.semmns=512 kern.ipc.semmnu=256 kern.ipc.semumr=200 vm.pmap.shpgperproc=400 vm.pmap.pv_entry_max=50331648 # sysctl -a kern.ipc.shm_allow_removed: 0 kern.ipc.shm_use_phys: 1 kern.ipc.shmall: 4189816 kern.ipc.shmseg: 128 kern.ipc.shmmni: 192 kern.ipc.shmmin: 1 kern.ipc.shmmax: 17161486336 kern.features.sysv_shm: 1 kern.features.posix_shm: 1 I hope that helps a little bit with value tuning, Frank Am 2012-11-05 01:54, schrieb Yuri: > When I am setting shared_buffers=6GB in postgresql.conf it fails to start: > DETAIL: Failed system call was shmget(key=5432001, size=6612361216, > 03600). > even though kern.ipc.shmmax is set to ~7GB: > $ sysctl -a | grep shm > kern.ipc.shm_allow_removed: 0 > kern.ipc.shm_use_phys: 0 > kern.ipc.shmall: 1310720 > kern.ipc.shmseg: 128 > kern.ipc.shmmni: 192 > kern.ipc.shmmin: 1 > kern.ipc.shmmax: 7000000000 > kern.features.sysv_shm: 1 > kern.features.posix_shm: 1 > > There are 17GB free memory as reported by top(1). > > Why shmget fails despite kern.ipc.shmmax is being high enough? > Experimentally I found that shared_buffers=5GB also fails but 4GB > succeeds. Is there another system limit on shmem besides kern.ipc.shmmax ? > > 9.1-RC3 and64 > > Yuri > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org" > -- Frank BRONIEWSKI METRICO s.à r.l. géomètres technologies d'information géographique rue des Romains 36 L-5433 NIEDERDONVEN tél.: +352 26 74 94 - 28 fax.: +352 26 74 94 99 http://www.metrico.lu