From owner-freebsd-hackers@FreeBSD.ORG Fri Mar 13 09:50:15 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 654EE1065673 for ; Fri, 13 Mar 2009 09:50:15 +0000 (UTC) (envelope-from freebsd-hackers@m.gmane.org) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by mx1.freebsd.org (Postfix) with ESMTP id E057B8FC13 for ; Fri, 13 Mar 2009 09:50:14 +0000 (UTC) (envelope-from freebsd-hackers@m.gmane.org) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1Li41u-0004FC-6X for freebsd-hackers@freebsd.org; Fri, 13 Mar 2009 09:50:14 +0000 Received: from lara.cc.fer.hr ([161.53.72.113]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 13 Mar 2009 09:50:14 +0000 Received: from ivoras by lara.cc.fer.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 13 Mar 2009 09:50:14 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-hackers@freebsd.org From: Ivan Voras Date: Fri, 13 Mar 2009 10:49:33 +0100 Lines: 66 Message-ID: References: <1235404207.31655.2085.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com> <1236877076.15167.3946.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig5E130D256A022E62CFDB41AE" X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: lara.cc.fer.hr User-Agent: Thunderbird 2.0.0.19 (X11/20090105) In-Reply-To: <1236877076.15167.3946.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com> X-Enigmail-Version: 0.95.0 Sender: news Cc: pgsql-performance@postgresql.org 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: Fri, 13 Mar 2009 09:50:15 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig5E130D256A022E62CFDB41AE Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Brian A. Seklecki wrote: > Thanks to all; with the r1.114 changes, our staff reports the following= : >=20 > "Postgres is able to start with a ~3GB postgresql.conf(5) $shared_buffe= r > on 8-CURRENT/amd64: It has recently also been MFC-ed to 7-STABLE :) (beware of instabilities and debugging in -CURRENT!) > PID USERNAME THR PRI NICE SIZE RES STATE TIME WCPU COMMAND > 1036 pgsql 1 44 0 3013M 79296K select 0:00 0.00% postgre= s >=20 > kern.ipc.shmall: 786432 > kern.ipc.shmmax: 3221225472 >=20 > FreeBSD db0X 8.0-CURRENT FreeBSD 8.0-CURRENT #0: Thu Mar 12 09:38:36 ED= T > 2009 foo@db02:/usr/obj/usr/src/sys/GENERIC amd64 >=20 > ~BAS >=20 > 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=3D2200000000 >>>>> 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=3Dkern/130274 >> >> We'd be happy to sponsor development in -current to address this >> limitation. ~BAS >=20 >=20 > _______________________________________________ > freebsd-hackers@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-hackers > To unsubscribe, send any mail to "freebsd-hackers-unsubscribe@freebsd.o= rg" >=20 --------------enig5E130D256A022E62CFDB41AE Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJuiw0ldnAQVacBcgRAkDrAKCRB9SD6WCBdARZrEATnVlTis2WxQCgoV7y WAddILKictTEFimgVr077ZM= =b2OD -----END PGP SIGNATURE----- --------------enig5E130D256A022E62CFDB41AE--