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: (view raw, whole thread or download thread mbox)
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 Lustig
CTO, MavenHaven Inc.
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


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-2017 The PostgreSQL Global Development Group