Re: Restoring large tables with COPY

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Restoring large tables with COPY
Дата
Msg-id 17945.1008093973@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Restoring large tables with COPY  (Marko Kreen <marko@l-t.ee>)
Ответы Re: Restoring large tables with COPY  (Marko Kreen <marko@l-t.ee>)
Список pgsql-hackers
Marko Kreen <marko@l-t.ee> writes:
> Look at the attached Python script, it reproduces the problem.

Hmm.  You'd probably have much better luck if you rewrote the check_code
function in plpgsql: that should eliminate the memory-leak problem, and
also speed things up because plpgsql knows about caching query plans
across function calls.  IIRC, sql functions don't do that.

The memory leakage is definitely a bug, but not one that is going to get
fixed for 7.2.  It'll take some nontrivial work on the SQL function
executor...
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Marko Kreen
Дата:
Сообщение: Re: Restoring large tables with COPY
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: pg_dump: Sorted output, referential integrity