Thanks for your quick responce.
I will ask our admin to do that .
Regards
Omid Omoomi
>From: Alexander N Shulyak <alec@nikts.nk.ukrtel.net>
>To: omid omoomi <oomoomi@hotmail.com>
>CC: pgsql-admin@postgreSQL.org
>Subject: Re: [ADMIN] Memorry allocation problem
>Date: Sun, 30 Apr 2000 15:18:52 +0300
>
>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
>
>
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
