Having problem retrieving huge? table

From: Ana Roizen <aroizen(at)sinectis(dot)com(dot)ar>
To: pgsql-sql(at)postgresql(dot)org
Subject: Having problem retrieving huge? table
Date: 1999-05-10 12:47:37
Message-ID: 3736D569.F5A087E2@sinectis.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Frank Morton 1999-05-10 13:17:05 Slow Inserts Leads To Unable To Dump
Previous Message Wayne Piekarski 1999-05-10 12:30:44 Re: [HACKERS] Re: INSERT/UPDATE waiting (another example)