Re: array_agg crash? - Mailing list pgsql-general

From Chris Spotts
Subject Re: array_agg crash?
Date
Msg-id 00cb01ca0a0f$3bd06220$b3712660$@com
Whole thread Raw
In response to Re: array_agg crash?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: array_agg crash?
List pgsql-general
> "Chris Spotts" <rfusca@gmail.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...


pgsql-general by date:

Previous
From: Murat Kabilov
Date:
Subject: element from an array by its index
Next
From: bricklen
Date:
Subject: Re: commercial adaptation of postgres