Received: from ncc1701.cistron.net (ncc1701.cistron.net [195.64.68.38]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f34KXo892735 for ; Wed, 4 Apr 2001 16:33:50 -0400 (EDT) (envelope-from news@uucp.cistron.nl) Received: from news by ncc1701.cistron.net with local (Exim 3.20 #1 (Debian)) id 14ktyN-0003BM-00 for ; Wed, 04 Apr 2001 22:33:47 +0200 From: jdassen@cistron.nl (J.H.M. Dassen (Ray)) Subject: Re: Memory exhaustion Date: Wed, 4 Apr 2001 20:33:47 +0000 (UTC) Organization: Cistron Internet Services B.V. Lines: 20 Message-ID: References: <20010404184509.25903.qmail@web6303.mail.yahoo.com> X-Trace: ncc1701.cistron.net 986416427 7078 195.64.65.236 (4 Apr 2001 20:33:47 GMT) X-Complaints-To: abuse@cistron.nl To: pgsql-sql@postgresql.org Errors-To: news@news.cistron.nl X-Archive-Number: 200104/58 X-Sequence-Number: 2397 Srikanth Rao wrote: >marketingbyoffice is a view. How is it defined? [*] >010404.13:52:28.691 [1352] FATAL 1: Memory exhausted in AllocSetAlloc() Have you followed the suggestion at http://www.postgresql.org/docs/faq-english.html#4.19 ? HTH, Ray [*] Not just out of idle curiosity; I'm aware of at least one operator/function that can trigger this behaviour in 7.0.3; see http://bugs.debian.org/92705 -- What is this talk of software 'releases'? Klingons do not 'release' software; our software ESCAPES, leaving a bloody trail of designers and quality assurance people in its wake!