Re: Functions with COPY

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Rod Taylor <pg(at)rbt(dot)ca>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Functions with COPY
Date: 2003-11-27 15:19:34
Message-ID: 20031127151934.GE24094@ns.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

* Rod Taylor (pg(at)rbt(dot)ca) wrote:
> How about COPY into a TEMP TABLE for 10k lines, then do an
> insert into real_table .... select .... from temp_table;
> which converts the data?
>
> You could of course thread the load so 2 or 3 processes execute the data
> import.

Sure, this would work, but it's a heck of alot more work from a
processing standpoint than either of the other options...

Stephen

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2003-11-27 15:21:06 Re: Functions with COPY
Previous Message Jan Wieck 2003-11-27 15:01:10 Re: pg_restore and create FK without verification check