Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id F1F8F9FA21F for ; Tue, 16 Oct 2007 11:22:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 96339-02-3 for ; Tue, 16 Oct 2007 11:22:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from fhw-relay07.plus.net (fhw-relay07.plus.net [212.159.14.215]) by postgresql.org (Postfix) with ESMTP id DB83E9FA2B2 for ; Tue, 16 Oct 2007 11:22:40 -0300 (ADT) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by fhw-relay07.plus.net with esmtp (Exim) id 1IhnJc-00080k-3k; Tue, 16 Oct 2007 15:22:36 +0100 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id E950E27404F; Tue, 16 Oct 2007 15:22:35 +0100 (BST) Message-ID: <4714C92B.6010909@archonet.com> Date: Tue, 16 Oct 2007 15:22:35 +0100 From: Richard Huxton User-Agent: Thunderbird 2.0.0.6 (X11/20070728) MIME-Version: 1.0 To: Jason Lustig CC: pgsql-performance@postgresql.org Subject: Re: Autovacuum running out of memory References: <374EB3D1-EE74-4B8C-9EEC-104ADD097568@brandeis.edu> <4714A458.5060408@archonet.com> <4714AD30.6000103@archonet.com> <57031F92-40D5-4832-8B76-FB73E510C735@brandeis.edu> <4714C426.3080207@archonet.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/177 X-Sequence-Number: 27199 Jason Lustig wrote: > I ran "ulimit -a" for the postgres user, and here's what I got: > max memory size (kbytes, -m) 200000 > virtual memory (kbytes, -v) 200000 There you go - you probably are exceeding these. Add some lines to /etc/security/limits.conf to increase them. -- Richard Huxton Archonet Ltd