Re: C program Killed

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: C program Killed
Дата
Msg-id 16437.1026394618@sss.pgh.pa.us
обсуждение исходный текст
Ответ на C program Killed  ("Patrick L. Nolan" <pln@cosmic.stanford.edu>)
Список 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 по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: inner join between database
Следующее
От: Tom Lane
Дата:
Сообщение: Re: workaround for lack of REPLACE() function