Re: Restoring large tables with COPY

From: Marko Kreen <marko(at)l-t(dot)ee>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Restoring large tables with COPY
Date: 2001-12-11 19:39:48
Message-ID: 20011211193948.GA7094@l-t.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Dec 11, 2001 at 01:06:13PM -0500, Tom Lane wrote:
> Marko Kreen <marko(at)l-t(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Doug Royer 2001-12-11 20:04:20 Re: Explicit configuration file
Previous Message Marko Kreen 2001-12-11 19:37:58 Re: Restoring large tables with COPY