From owner-freebsd-questions@FreeBSD.ORG  Sat Apr 22 19:58:54 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 6164F16A410
	for <freebsd-questions@freebsd.org>;
	Sat, 22 Apr 2006 19:58:54 +0000 (UTC)
	(envelope-from lists@stringsutils.com)
Received: from zoraida.natserv.net (p65-147.acedsl.com [66.114.65.147])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 015E043D48
	for <freebsd-questions@freebsd.org>;
	Sat, 22 Apr 2006 19:58:53 +0000 (GMT)
	(envelope-from lists@stringsutils.com)
Received: from zoraida.natserv.net (localhost.natserv.net [127.0.0.1])
	by zoraida.natserv.net (Postfix) with ESMTP id F1131B84D
	for <freebsd-questions@freebsd.org>;
	Sat, 22 Apr 2006 15:58:52 -0400 (EDT)
Received: from zoraida.natserv.net (zoraida.natserv.net [66.114.65.147])
	by zoraida.natserv.net (Postfix) with ESMTP id B2255B84B
	for <freebsd-questions@freebsd.org>;
	Sat, 22 Apr 2006 15:58:52 -0400 (EDT)
Message-ID: <cone.1145735932.540393.55795.1000@zoraida.natserv.net>
X-Mailer: http://www.courier-mta.org/cone/
From: Francisco Reyes <lists@stringsutils.com>
To: Free BSD Questions list <freebsd-questions@freebsd.org>
Date: Sat, 22 Apr 2006 15:58:52 -0400
Mime-Version: 1.0
Content-Type: text/plain; format=flowed; charset="US-ASCII"
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: ClamAV using ClamSMTP
Subject: How to increase memory for an application?
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sat, 22 Apr 2006 19:58:54 -0000

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.