Re: C program Killed - Mailing list pgsql-general

From Tom Lane
Subject Re: C program Killed
Date
Msg-id 16437.1026394618@sss.pgh.pa.us
Whole thread Raw
In response to C program Killed  ("Patrick L. Nolan" <pln@cosmic.stanford.edu>)
List pgsql-general
"Patrick L. Nolan" <pln@cosmic.stanford.edu> writes:
> I practiced running it on a small table and everything
> was OK.  When I switched to a large table, with 100
> times as many rows, the program ran for a while and
> then said
> Killed

My guess is you're running out of memory on the client side.
Consider using a cursor so you can read the data in units
smaller than 14M rows at a time ...

            regards, tom lane

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: inner join between database
Next
From: Tom Lane
Date:
Subject: Re: workaround for lack of REPLACE() function