shmmax tops out at 2G?

[Brian A. Seklecki]

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 at 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