Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id EB0989F96B2 for ; Wed, 29 Aug 2007 14:43:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 44573-07-2 for ; Wed, 29 Aug 2007 14:43:51 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.232]) by postgresql.org (Postfix) with ESMTP id 82D0F9F9C1A for ; Wed, 29 Aug 2007 14:43:51 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id l8so195970nzf for ; Wed, 29 Aug 2007 10:43:50 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=JQZsFR1IwV9/HuGUkPA8DTem2ML5F4ydKspL9wRoun1ZL8niEv7Nqm4daf9ABvOWlWzZGK0i+LBLvYfhEHyLqcQB0zY5Q/8Ht605CY/8OMJRfKTmrbggt72TB/ml+kIHosO71qLPoE+E6oie3+0q4ykenBajZZprTUN7zRADDow= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=JzuNgsNTmIZkICnaehVzYkGC031+wMji94RYDl53YO3W8jLqsOSAcOd9DJB3EUuXUlP5teApDRRZgbqPUKa0gW1gwTmbwVpKxvVeB4pvzHwRr+8nDQt5kTaXXAhSyxRl6CEUFJ3QGpWCT/lOYBJH3i/0zftI9ok+5tPe9bjG2iI= Received: by 10.141.27.18 with SMTP id e18mr461290rvj.1188409430076; Wed, 29 Aug 2007 10:43:50 -0700 (PDT) Received: by 10.141.159.11 with HTTP; Wed, 29 Aug 2007 10:43:50 -0700 (PDT) Message-ID: Date: Wed, 29 Aug 2007 12:43:50 -0500 From: "Scott Marlowe" To: Geoffrey Subject: Re: vacuum killed because of out of memory Cc: pgsql-admin@postgresql.org In-Reply-To: <46D2DBF6.609@serioustechnology.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <46D2DBF6.609@serioustechnology.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/401 X-Sequence-Number: 26732 On 8/27/07, Geoffrey 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