[nycbug-talk] Increasing memory for an application

Bob Ippolito bob at redivi.com
Sun Apr 23 13:22:34 EDT 2006

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.maxdsiz="1073741824" # 1GB
kern.dfldsiz="1073741824" # 1GB
kern.maxssiz="134217728" # 128MB


More information about the talk mailing list