Memorry allocation problem - Mailing list pgsql-admin

From omid omoomi
Subject Memorry allocation problem
Date
Msg-id 20000430095648.58002.qmail@hotmail.com
Whole thread Raw
List pgsql-admin
Hie,
I have a test table which contains about 1,300,000 rows, each row has 5
int4/datetime/text fields. When I start "select * from table" in psql
environment, after about 2~3 mins this message shows up :
malloc: Cannot allocate memory
How can It be fixed? Is that a matter of OS or pg?
I'm using :
[PostgreSQL 6.5.2 on i386-unknown-freebsd3.2, compiled by gcc 2.7.2.1]

TIA,
Omid Omoomi

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com


pgsql-admin by date:

Previous
From: "Vladimir V. Zolotych"
Date:
Subject: rules bug
Next
From: Alexander N Shulyak
Date:
Subject: Re: Memorry allocation problem