omid omoomi wrote:
> 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
Hi.
There are some limits in FreeBSD according to user's login class
in Your password entry.
To avoid limitations set login class root (or ask to do it Your system
administrator).
To SELECT all from Your table You'll have enough of swapping space (I think
500-600Mb).
Alexander N Shulyak