From: | Nick <t32(at)2thebatcave(dot)com> |
---|---|
To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: autovacuum launcher process eating up 17G+ of ram? |
Date: | 2010-10-25 17:01:28 |
Message-ID: | AANLkTi=Mh=pv7Ai+L17cbjgsExMbncHG5fMTvj5_wCAe@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Fri, Oct 22, 2010 at 11:17 AM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> I've not seen anything remotely like that. I wonder what's
> different....
I did a test with the same postgres build (and autovacuum_naptime = 1
as well) on the same OS with only the system databases (postgres,
template0, template1), and after the weekend the memory utilization
was acceptable:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
14879 pgsql 15 0 312m 177m 1108 S 0.0 8.8 0:24.43 postgres
However on the other machine which has 136 total databases (133 user +
the same 3 system ones listed above), the kernel had to kill off the
postgres process since the box ran out of memory (the box has 8GB ram
+ 30GB swap), and I see it climbing again.
It seems like the problem is a function of how many databases there are.
> Is there anything unusual in the logs?
I set log_autovacuum_min_duration = 0 but that doesn't even seem to
show that anything is being vacuumed. The only thing unusual in the
logs was a result of the box running out of memory and the kernel
killing off processes.
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2010-10-25 17:31:59 | Re: autovacuum launcher process eating up 17G+ of ram? |
Previous Message | Greg Smith | 2010-10-25 15:22:46 | Re: pg_ctl: server does not shut down |