Date: Wed, 28 Feb 2007 15:05:01 -0800 (PST) From: Dino Vliet <dino_vliet@yahoo.com> To: freebsd-questions@freebsd.org Subject: tweaking kern.ipc.shmmax Message-ID: <60514.55113.qm@web51106.mail.yahoo.com>
next in thread | raw e-mail | index | archive | help
Hi peeps,=0A=0AI have a amd64 system running freebsd6.1 with 3 GB ram. I wa= nt to use this a s my primary reserach database and installed postgresql on= it. There they are talking about increasing some shared buffers value.=0A= =0AHowever, if I do increase that shared buffer value to even 64MB (while I= hoped to increase it up to 256MB), in the var/log/messages file I get this= error:=0A=0AFeb 28 23:43:09 zouk postgres[826]: [1-1] FATAL: could not cr= eate shared memory segment: Cannot allocate memory=0AFeb 28 23:43:09 zouk p= ostgres[826]: [1-2] DETAIL: Failed system call was shmget(key=3D5432001, s= ize=3D71942144, 03600).=0AFeb 28 23:43:09 zouk postgres[826]: [1-3] HINT: = This error usually means that PostgreSQL's request for a shared memory segm= ent exceeded available memory or swap space.=0AFeb 28 23:43:09 zouk postgre= s[826]: [1-4] To reduce the request size (currently 71942144 bytes), reduc= e PostgreSQL's shared_buffers parameter (currently 8192) and/or its=0AFeb 2= 8 23:43:09 zouk postgres[826]: [1-5] max_connections parameter (currently = 3).=0AFeb 28 23:43:09 zouk postgres[826]: [1-6] The PostgreSQL docume= ntation contains more information about shared memory configuration.=0A=0A= =0AHowever, look at the values I have put in my /etc/rc.conf file:=0A=0Asys= ctl -w kern.ipc.shmmax=3D1954311424=0Asysctl -w kern.ipc.shmall=3D16384=0A= =0AI don't understand why the value that seems smaller, 71942144, doesn't f= it in the shmmax value.=0A=0ACan anyone be of assistance? Do I need to rebu= ild my kernel? Someone advised in 2006 that these value should be in your k= ernel:=0A options PMAP_SHPGPERPROC=3D201=0Aoptions KVA_PAGE= S=3D260=0A=0AThe fact is that tha both are not in my current kernel, but ev= en if they did, I wouldn't know which values to give them.=0ACan anyone hel= p me out?=0A=0AThanks=0A=0A=0A=0A=0A=0A =0A________________________________= ____________________________________________________=0AAny questions? Get a= nswers on any topic at www.Answers.yahoo.com. Try it now.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?60514.55113.qm>