[nycbug-talk] Increasing memory for an application

[Bob Ippolito]

On Apr 22, 2006, at 9:57 PM, Francisco Reyes wrote:

> Tried freebsd-questions... without much luck..
>
> --
> While trying to do a quiery in the postgresql client got an error  
> "out of
> memory for query result". After checking the postgresql
> list I got this reply
>
> "Process memory allowed to the client; this is not a server-side  
> error."
>
>
> How would I crease the memory allowed to a specific program?
>
> I looked at /etc/login.conf and there I see:
> :datasize=unlimited:\
> :stacksize=unlimited:\
> :memorylocked=unlimited:\
> :memoryuse=unlimited:\
> :filesize=unlimited:\
>
>
> Is this a kernel setting?
> Looking at top, it seems the psql client got to 512MB before it  
> reported the
> error.

Default max process size on FreeBSD is 512MB.  You need to create / 
boot/loader.conf and tweak the appropriate settings then reboot.   
Here's what mine looks like:

kern.ipc.semmni=256
kern.ipc.semmns=512
kern.ipc.semmnu=256
kern.maxdsiz="1073741824" # 1GB
kern.dfldsiz="1073741824" # 1GB
kern.maxssiz="134217728" # 128MB

-bob