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