Thread: out of memory error on dumping over 1,000,000 to file

out of memory error on dumping over 1,000,000 to file

From
Clayton Cottingham
Date:
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?






Re: [SQL] more info on ..out of memory error on dumping over 1,000,000 to file

From
Clayton Cottingham
Date:
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