Received: from dfw-ix11.ix.netcom.com (dfw-ix11.ix.netcom.com [206.214.98.11]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA27564 for ; Wed, 25 Aug 1999 16:57:07 -0400 (EDT) (envelope-from drfrog@smartt.com) Received: (from smap@localhost) by dfw-ix11.ix.netcom.com (8.8.4/8.8.4) id PAA20379 for ; Wed, 25 Aug 1999 15:56:08 -0500 (CDT) Received: from 00-10-4b-66-ed-f1.bconnected.net(209.53.22.117) by dfw-ix11.ix.netcom.com via smap (V1.3) id rma020220; Wed Aug 25 15:55:12 1999 Sender: DrFrog@ix.netcom.com Message-ID: <37C45A55.ABCADAF9@smartt.com> Date: Wed, 25 Aug 1999 21:04:21 +0000 From: Clayton Cottingham X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.3.2 i586) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: Re: [SQL] more info on ..out of memory error on dumping over 1, 000, 000 to file References: <37C26D28.E0C908BF@smartt.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Clayton Cottingham wrote: > i keep gettin' out of memory errors when running this type of command on > my tables > > psql database -c "select column1,column2 from table;" > 2columnsout > > the reason im doing it this way is to just retrieve two columns, is > there as another way to do this ? i looked at the -o filename option,it > still produced the same error!? > > possible something to add to pg_dump? the ability to dump certain > columns? > > ************ it seems the dump stops at approx the half way point this happens even on a limited selectect as if table has 1 mill rows select * from table limit 500000,75000; it would produce an out of memory has anyone else experienced this? my hardware/os is k166 w 64mb ram running on linux kernel 2.3.2 and glibc2.1