Date: Thu, 12 Mar 2009 12:57:56 -0400 From: "Brian A. Seklecki" <lavalamp@spiritual-machines.org> To: freebsd-hackers@freebsd.org, pgsql-performance@postgresql.org Cc: spolyack@gmail.com, wmoran <wmoran@potentialtech.com> Subject: Re: shmmax tops out at 2G? Message-ID: <1236877076.15167.3946.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com> In-Reply-To: <1235404207.31655.2085.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com> References: <1235404207.31655.2085.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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 <wmoran at collaborativefusion.com>: > > >> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1236877076.15167.3946.camel>