Обсуждение: Memorry allocation problem
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
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
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