From owner-freebsd-hackers@FreeBSD.ORG Thu Mar 12 16:57:57 2009 Return-Path: Delivered-To: freebsd-hackers@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 66A5E1065675 for ; Thu, 12 Mar 2009 16:57:57 +0000 (UTC) (envelope-from lavalamp@spiritual-machines.org) Received: from mx04.pub.collaborativefusion.com (mx04.pub.collaborativefusion.com [206.210.72.84]) by mx1.freebsd.org (Postfix) with ESMTP id 312F58FC12 for ; Thu, 12 Mar 2009 16:57:56 +0000 (UTC) (envelope-from lavalamp@spiritual-machines.org) Received: from [192.168.2.161] ([206.210.89.202]) by mx04.pub.collaborativefusion.com (StrongMail Enterprise 4.1.1.4(4.1.1.4-47689)); Thu, 12 Mar 2009 12:57:56 -0400 X-VirtualServerGroup: Default X-MailingID: 00000::00000::00000::00000::::5 X-SMHeaderMap: mid="X-MailingID" X-Destination-ID: freebsd-hackers@freebsd.org X-SMFBL: ZnJlZWJzZC1oYWNrZXJzQGZyZWVic2Qub3Jn From: "Brian A. Seklecki" To: freebsd-hackers@freebsd.org, pgsql-performance@postgresql.org In-Reply-To: <1235404207.31655.2085.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com> References: <1235404207.31655.2085.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com> Content-Type: text/plain Date: Thu, 12 Mar 2009 12:57:56 -0400 Message-Id: <1236877076.15167.3946.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com> Mime-Version: 1.0 X-Mailer: Evolution 2.24.5 (2.24.5-1.fc10) Content-Transfer-Encoding: 7bit X-Mailman-Approved-At: Thu, 12 Mar 2009 17:19:55 +0000 Cc: spolyack@gmail.com, wmoran Subject: Re: shmmax tops out at 2G? X-BeenThere: freebsd-hackers@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Technical Discussions relating to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 12 Mar 2009 16:57:58 -0000 Thanks to all; with the r1.114 changes, our staff reports the following: "Postgres is able to start with a ~3GB postgresql.conf(5) $shared_buffer on 8-CURRENT/amd64: PID USERNAME THR PRI NICE SIZE RES STATE TIME WCPU COMMAND 1036 pgsql 1 44 0 3013M 79296K select 0:00 0.00% postgres kern.ipc.shmall: 786432 kern.ipc.shmmax: 3221225472 FreeBSD db0X 8.0-CURRENT FreeBSD 8.0-CURRENT #0: Thu Mar 12 09:38:36 EDT 2009 foo@db02:/usr/obj/usr/src/sys/GENERIC amd64 ~BAS On Mon, 2009-02-23 at 10:50 -0500, Brian A. Seklecki wrote: > > On Wed, 2006-Dec-13 10:50:21 -0500, Bill Moran wrote: > > >In response to Bill Moran : > > >> sysctl kern.ipc.shmmax=2200000000 > > >> kern.ipc.shmmax: 2100000000 -> -2094967296 > > Someone was nice enough to file a PR related to this: > > http://www.freebsd.org/cgi/query-pr.cgi?pr=kern/130274 > > We'd be happy to sponsor development in -current to address this > limitation. ~BAS