Received: from web6303.mail.yahoo.com (web6303.mail.yahoo.com [128.11.22.140]) by postgresql.org (8.11.3/8.11.1) with SMTP id f34IjG876578 for ; Wed, 4 Apr 2001 14:45:16 -0400 (EDT) (envelope-from srirao_us@yahoo.com) Message-ID: <20010404184509.25903.qmail@web6303.mail.yahoo.com> Received: from [143.209.7.248] by web6303.mail.yahoo.com; Wed, 04 Apr 2001 11:45:09 PDT Date: Wed, 4 Apr 2001 11:45:09 -0700 (PDT) From: Srikanth Rao Subject: Memory exhaustion To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200104/54 X-Sequence-Number: 2393 marketingbyoffice is a view. I start the postmaster, then issue the following query in psql console. It goes to sleep forever:-) Why? The log is as follows: ------log ----- 010404.13:49:14.612 [1352] StartTransactionCommand 010404.13:49:14.612 [1352] query: SELECT * INTO TEMP TABLE marketingbylocation FROM marketingbyoffice; 010404.13:49:14.624 [1352] ProcessQuery 010404.13:52:28.691 [1352] FATAL 1: Memory exhausted in AllocSetAlloc() 010404.13:52:32.568 [1352] AbortCurrentTransaction __________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/