Received: from odin.sinectis.com.ar (IDENT:root@odin.sinectis.com.ar [200.16.183.2]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA18484 for ; Mon, 10 May 1999 08:44:37 -0400 (EDT) (envelope-from aroizen@sinectis.com.ar) Received: from sinectis.com.ar (IDENT:nobody@ix.sinectis.com.ar [200.5.70.4]) by odin.sinectis.com.ar (8.9.1/8.9.1) with ESMTP id JAA06497 for ; Mon, 10 May 1999 09:44:35 -0300 Sender: root@odin.sinectis.com.ar Message-ID: <3736D569.F5A087E2@sinectis.com.ar> Date: Mon, 10 May 1999 09:47:37 -0300 From: Ana Roizen X-Mailer: Mozilla 4.07 [en] (X11; I; Linux 2.0.36 i686) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Having problem retrieving huge? table Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I have a table with aproximately 30 columns and 45000 tuples . When I execute (from psql) "select * from mytable" it shows me one of the following messages: 1)Can't allocate memory or 2) pqReadData() - backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. We have lost the connection to the backend, so further processing is impossible. Terminating. I also receive the message 2) when querying : "select oid from mytable where oid >= all(select oid from mytable)" Please, I aprecciate your help. Ana Roizen.