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

Re: Autovacuum running out of memory

From: Jason Lustig <lustig(at)brandeis(dot)edu>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Autovacuum running out of memory
Date: 2007-10-16 11:55:35
Message-ID: E8328FA1-800E-4684-93D2-A1002BB72396@brandeis.edu (view raw or flat)
Thread:
Lists: pgsql-performance
There isn't any more error message than this... it simply repeats  
every minute or so, which is really quite strange. And the user & db  
is really blank in the log, I didn't trim it (if I did I would have  
replaced it with dummy values).

I'm using pg 8.2.4 on Linux 2.6.15.

Jason

--
Jason Lustig
CTO, MavenHaven Inc.
www.mavenhaven.com
Where the Community Finds Wisdom

Israel:	054-231-8476
U.S.:	716-228-8729
Skype:	jasonlustig


On Oct 16, 2007, at 7:45 AM, Richard Huxton wrote:

> 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: Richard HuxtonDate: 2007-10-16 12:23:12
Subject: Re: Autovacuum running out of memory
Previous:From: Richard HuxtonDate: 2007-10-16 11:45:28
Subject: Re: Autovacuum running out of memory

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