X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id D8860D1C7F1 for ; Thu, 14 Aug 2003 11:48:31 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 81813-06 for ; Thu, 14 Aug 2003 08:46:56 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id C7D41D1C94C for ; Thu, 14 Aug 2003 08:48:20 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h7EBjkSa015590; Thu, 14 Aug 2003 07:45:46 -0400 (EDT) To: Bertrand Petit Cc: pgsql-performance@postgresql.org Subject: Re: 7.4 beta 1 getting out of swap In-reply-to: <20030814122130.A3583@memo.frmug.org> References: <20030814122130.A3583@memo.frmug.org> Comments: In-reply-to Bertrand Petit message dated "Thu, 14 Aug 2003 12:21:30 +0200" Date: Thu, 14 Aug 2003 07:45:46 -0400 Message-ID: <15589.1060861546@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/253 X-Sequence-Number: 3070 Bertrand Petit writes: > I recently switched to 7.4 beta 1, one query that used to be > corectly executed uder 7.3.3 albeit slowly now abnormaly ends when the > backend can't get more memory when it ate about 480 MB of swap space. Please show us the memory context size info that the backend dumps to stderr when it reports "out of memory". regards, tom lane