Re: vacuum killed because of out of memory

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Geoffrey <lists(at)serioustechnology(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: vacuum killed because of out of memory
Date: 2007-08-27 14:21:23
Message-ID: 20070827142123.GA11880@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Geoffrey wrote:

> Aug 27 00:59:07 gan-lxc-01 kernel: Out of Memory: Killed process 26169
> (postmaster).

> So, my question is, based on the configuration of this box and the
> configuration of postgresql, can anyone point to anything that might cause
> this to happen?

An operating system configured to overcommit memory will do this. The
usual suggestion is to configure it not to.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Dimitri Fontaine 2007-08-27 15:53:59 Re: {Spam} Copy cmd error
Previous Message Geoffrey 2007-08-27 14:13:10 vacuum killed because of out of memory