Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5BDwFE91872 for ; Mon, 11 Jun 2001 09:58:15 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f5BDud004392; Mon, 11 Jun 2001 09:56:39 -0400 (EDT) To: David Richter cc: sg9@sg9.de, pgsql-sql@postgresql.org Subject: Re: Memory exhausted In-reply-to: <3B24B8CC.15C55147@DKFZ-heidelberg.de> References: <3B24B8CC.15C55147@DKFZ-heidelberg.de> Comments: In-reply-to David Richter message dated "Mon, 11 Jun 2001 14:25:48 +0200" Date: Mon, 11 Jun 2001 09:56:38 -0400 Message-ID: <4389.992267798@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200106/154 X-Sequence-Number: 3375 David Richter writes: > I used a self written funtion in plpgsql with a database of 2 Gigabyte > size. My server has 384 Megabytes of RAM. > So I got this error by calling the following function: > psql:restructure.sql:139: FATAL 1: Memory exhausted in AllocSetAlloc() Try updating to Postgres 7.1. regards, tom lane