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