Date: Fri, 13 Mar 2009 10:49:33 +0100 From: Ivan Voras <ivoras@freebsd.org> To: freebsd-hackers@freebsd.org Cc: pgsql-performance@postgresql.org Subject: Re: shmmax tops out at 2G? Message-ID: <gpda85$502$1@ger.gmane.org> In-Reply-To: <1236877076.15167.3946.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com> References: <1235404207.31655.2085.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com> <1236877076.15167.3946.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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 <wmoran at collaborativefusion.com>: >>>>> 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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?gpda85$502$1>