Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id E4F0E9FA580 for ; Tue, 16 Oct 2007 08:45:37 -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 24369-03 for ; Tue, 16 Oct 2007 08:45:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from pih-relay05.plus.net (pih-relay05.plus.net [212.159.14.132]) by postgresql.org (Postfix) with ESMTP id 262A59FA18C for ; Tue, 16 Oct 2007 08:45:34 -0300 (ADT) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by pih-relay05.plus.net with esmtp (Exim) id 1IhkrZ-0004aq-T3; Tue, 16 Oct 2007 12:45:30 +0100 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 6A66D274057; Tue, 16 Oct 2007 12:45:28 +0100 (BST) Message-ID: <4714A458.5060408@archonet.com> Date: Tue, 16 Oct 2007 12:45:28 +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> In-Reply-To: <374EB3D1-EE74-4B8C-9EEC-104ADD097568@brandeis.edu> 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/170 X-Sequence-Number: 27192 Not really a performance question, but... Jason Lustig wrote: > Whenever I turn on Autovacuum on my database, I get a ton of error > messages like this in my Postgres log: > > Oct 16 06:43:47 [2897]: [1-1] user=,db= ERROR: out of memory > Oct 16 06:43:47 [2897]: [1-2] user=,db= DETAIL: Failed on request of > size 524287998. > > It always fails on the same request. When I turn off autovacuum, they go > away. However, when I run VACUUM FULL manually, I don't get this error. Is there nothing before this giving the error message some context? Is the user and database really blank, or have you just trimmed those? What version of PG is this, and running on what O.S.? -- Richard Huxton Archonet Ltd