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

Re: vacuum killed because of out of memory

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(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-29 17:43:50
Message-ID: dcc563d10708291043o60270ca1yadff1e2dc9136f52@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On 8/27/07, Geoffrey <lists(at)serioustechnology(dot)com> wrote:
> I've recently reviewed the various recent threads on out of memory
> problems.  We just had a similar issue last night.  We have 11
> postmasters running on two machines in a cluster environment.  Five on
> one, six on the other.  They've been running in this manner for a little
> over a year now.

> 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?


Too high a setting for maint_work_mem

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2007-08-29 17:57:37
Subject: Re: How to monitor resources on Linux.
Previous:From: Jeff FrostDate: 2007-08-29 17:25:14
Subject: Re: How to monitor resources on Linux.

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