Re: convert an Insert Into... select from... to use COPY ? - Mailing list pgsql-admin

From Tom Lane
Subject Re: convert an Insert Into... select from... to use COPY ?
Date
Msg-id 15580.1247778514@sss.pgh.pa.us
Whole thread Raw
In response to convert an Insert Into... select from... to use COPY ?  (Kevin Kempter <kevink@consistentstate.com>)
List pgsql-admin
Kevin Kempter <kevink@consistentstate.com> writes:
> I have an sql stmt that runs:

> insert into x
> ( a.col1, a.col2, a.col3,b.col1,b.col2)
> select blah,blah,blah
> ...
> from giant_table a,
>      even_bigger_table b
> where.....

> I wonder, could I convert this to use COPY into the table (x) instead of the
> select stmt?

Why would you want to?  It's certain to be far slower.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Flush Shared Buffer Cache
Next
From: "Kevin Grittner"
Date:
Subject: Re: Hard link / rsync backup strategy successful