Re: array_agg() on a set larger than some arbitrary(?) limit causes runaway memory usage and eventually memory exhaustion

Hi,

On 19.10.2013 21:02, Valentine Gogichashvili wrote:
> Hi Frank,
>
> this is a little bit not relevant to the question itself. But to prevent
> OOM killer from currupting your database please consider this for your
> production environments:
> http://www.postgresql.org/docs/9.1/static/kernel-resources.html#LINUX-MEMORY-OVERCOMMIT

Not sure what's your suggestion? The problem is that the database is
actually using the memory, so overcommit is not directly applicable here.

He might easily add more swap to "fix" the issue, but it will take ages
to actually execute the query because of the overhead.

Tomas