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 12:23:12 |
Message-ID: | 4714AD30.6000103@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Jason Lustig wrote:
> 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).
Hmm - odd that you're not getting any connection details.
> I'm using pg 8.2.4 on Linux 2.6.15.
Fair enough.
>>> 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.
Well, since this is about 500MB and your maintenance_work_mem is set to
500MB that's the obvious place to start. It might just be that you've
not got enough free memory.
What happens if you set maintenance_work_mem to say 50MB?
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Lustig | 2007-10-16 13:32:54 | Re: Autovacuum running out of memory |
Previous Message | Jason Lustig | 2007-10-16 11:55:35 | Re: Autovacuum running out of memory |