Skip site navigation (1) Skip section navigation (2)

Re: Autovacuum running out of memory

From: Richard Huxton <dev(at)archonet(dot)com>
To: Jason Lustig <lustig(at)brandeis(dot)edu>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Autovacuum running out of memory
Date: 2007-10-16 11:45:28
Message-ID: 4714A458.5060408@archonet.com (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

Responses

pgsql-performance by date

Next:From: Jason LustigDate: 2007-10-16 11:55:35
Subject: Re: Autovacuum running out of memory
Previous:From: Jason LustigDate: 2007-10-16 11:12:11
Subject: Autovacuum running out of memory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group