Re: Restoring large tables with COPY

Поиск
Список
Период
Сортировка
От Marko Kreen
Тема Re: Restoring large tables with COPY
Дата
Msg-id 20011211193948.GA7094@l-t.ee
обсуждение исходный текст
Ответ на Re: Restoring large tables with COPY  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Tue, Dec 11, 2001 at 01:06:13PM -0500, Tom Lane wrote:
> 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.

And I thought that the 'sql' is the more lightweight approach...

Thanks, now it seems to work.

-- 
marko



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

Предыдущее
От: Doug Royer
Дата:
Сообщение: Re: Explicit configuration file
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Beta4 or RC1 ... ?