Re: Restoring large tables with COPY - Mailing list pgsql-hackers

From Marko Kreen
Subject Re: Restoring large tables with COPY
Date
Msg-id 20011211193948.GA7094@l-t.ee
Whole thread Raw
In response to Re: Restoring large tables with COPY  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Doug Royer
Date:
Subject: Re: Explicit configuration file
Next
From: Peter Eisentraut
Date:
Subject: Re: Beta4 or RC1 ... ?