How to increase memory for an application?

[Francisco Reyes]

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.