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

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

Previous
From: Marko Kreen
Date:
Subject: Re: Restoring large tables with COPY
Next
From: Stephan Szabo
Date:
Subject: Re: pg_dump: Sorted output, referential integrity