Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group