Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuum killed because of out of memory - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: vacuum killed because of out of memory
Date
Msg-id 20070827142123.GA11880@alvh.no-ip.org
Whole thread Raw
In response to vacuum killed because of out of memory  (Geoffrey <lists@serioustechnology.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Geoffrey
Date:
Subject: vacuum killed because of out of memory
Next
From: feng xinguo
Date:
Subject: use copy command!