Re: Autovacuum running out of memory

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