From owner-freebsd-stable@FreeBSD.ORG Wed Jun 29 20:41:04 2005 Return-Path: X-Original-To: stable@freebsd.org Delivered-To: freebsd-stable@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 8DD8C16A41C for ; Wed, 29 Jun 2005 20:41:04 +0000 (GMT) (envelope-from cswiger@mac.com) Received: from smtpout.mac.com (smtpout.mac.com [17.250.248.97]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7521C43D5D for ; Wed, 29 Jun 2005 20:41:04 +0000 (GMT) (envelope-from cswiger@mac.com) Received: from mac.com (smtpin08-en2 [10.13.10.153]) by smtpout.mac.com (Xserve/8.12.11/smtpout06/MantshX 4.0) with ESMTP id j5TKetRG027605; Wed, 29 Jun 2005 13:40:55 -0700 (PDT) Received: from [10.1.1.209] (nfw2.codefab.com [199.103.21.225] (may be forged)) (authenticated bits=0) by mac.com (Xserve/smtpin08/MantshX 4.0) with ESMTP id j5TKerXj004602; Wed, 29 Jun 2005 13:40:54 -0700 (PDT) In-Reply-To: <1120075946.19603.68.camel@lanshark.dmv.com> References: <1120050088.19603.7.camel@lanshark.dmv.com> <58067976-00C6-4380-90DF-F448D9008C81@khera.org> <1120075946.19603.68.camel@lanshark.dmv.com> Mime-Version: 1.0 (Apple Message framework v730) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <51C9ABA2-20B8-4DE8-B647-A26A168A78FC@mac.com> Content-Transfer-Encoding: 7bit From: Charles Swiger Date: Wed, 29 Jun 2005 16:40:52 -0400 To: Sven Willenberger X-Mailer: Apple Mail (2.730) Cc: Vivek Khera , stable@freebsd.org, postgres general Subject: Re: [GENERAL] PostgreSQL's vacuumdb fails to allocate memory for non-root users X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 29 Jun 2005 20:41:04 -0000 On Jun 29, 2005, at 4:12 PM, Sven Willenberger wrote: [ ... ] > Something I have noticed, > when the memory error occurs during the psql session (after a failed > vacuumdb attempt) the memory stays at 600+MB in top (under size) until > the psql session is closed -- that may just be the way top reports it > though. Double-check your system limits via "ulimit -a" or "ulimit -aH". By default, FreeBSD will probably restrict the maximum data size of the process to 512MB, which may be what you are running into. You can rebuild the kernel to permit a larger data size, or else tweak /boot/ loader.conf: echo 'kern.maxdsiz="1024M"' >> /boot/loader.conf -- -Chuck