Re: array_agg crash?

From: "Chris Spotts" <rfusca(at)gmail(dot)com>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: array_agg crash?
Date: 2009-07-21 14:26:25
Message-ID: 00cb01ca0a0f$3bd06220$b3712660$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> "Chris Spotts" <rfusca(at)gmail(dot)com> writes:
> > LOG: 00000: autovacuum launcher process (PID 10264) was terminated
> by
> > signal 9: Killed
>
> Looks like the OOM killer is loose on your system. Disable memory
> overcommit in the kernel and things will get better.
> http://www.postgresql.org/docs/8.4/static/kernel-
> resources.html#AEN24152
>
> regards, tom lane
[Spotts, Christopher]

That seems to have fixed it in the sense that it doesn't crash, but I killed
it after 15 minutes and no results...rather I tried to kill it, but it looks
like I'm going to have to -9 it...

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bricklen 2009-07-21 14:33:46 Re: commercial adaptation of postgres
Previous Message Tom Lane 2009-07-21 14:13:08 Re: ***UNCHECKED*** Re: memory leak occur when disconnect database