Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 7FA679FBE26
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 17 Jul 2007 18:01:24 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 52185-03 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 17 Jul 2007 18:01:13 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from pat.uio.no (pat.uio.no [129.240.10.15])
	by postgresql.org (Postfix) with ESMTP id B8CB09FBE2C
	for <pgsql-performance@postgresql.org>;
	Tue, 17 Jul 2007 18:01:17 -0300 (ADT)
Received: from mail-mx8.uio.no ([129.240.10.38])
	by pat.uio.no with esmtp (Exim 4.67)
	(envelope-from <tfinneid@ifi.uio.no>) id 1IAuAW-00027C-6T
	for pgsql-performance@postgresql.org; Tue, 17 Jul 2007 23:01:16 +0200
Received: from smtp.uio.no ([129.240.10.9] helo=mail-mx8.uio.no)
	by mail-mx8.uio.no with esmtp (Exim 4.67)
	(envelope-from <tfinneid@ifi.uio.no>) id 1IAuAV-00086X-TM
	for pgsql-performance@postgresql.org; Tue, 17 Jul 2007 23:01:16 +0200
Received: from 113.80-203-240.nextgentel.com ([80.203.240.113]
	helo=[10.0.0.128])
	by mail-mx8.uio.no with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.67)
	(envelope-from <tfinneid@ifi.uio.no>) id 1IAuAV-00086S-Np
	for pgsql-performance@postgresql.org; Tue, 17 Jul 2007 23:01:15 +0200
Message-ID: <469D2E1B.1090100@ifi.uio.no>
Date: Tue, 17 Jul 2007 23:01:15 +0200
From: Thomas Finneid <tfinneid@student.matnat.uio.no>
User-Agent: Thunderbird 1.5.0.12 (X11/20070604)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: insert vs select into performance
References: <469D1AD3.9030004@ifi.uio.no> <469D1E4F.5090805@tweakers.net>
In-Reply-To: <469D1E4F.5090805@tweakers.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-UiO-SPF-Received: 
X-UiO-Resend: resent
X-UiO-SPF-Received: 
X-UiO-Spam-info: not spam, SpamAssassin (score=0.0, required=12.0,
	autolearn=disabled, none)
X-UiO-Scanned: 3392259213336664B5205407D63C65FCA7A963FD
X-UiO-SPAM-Test: remote_host: 129.240.10.9 spam_score: 0 maxlevel 200
	minaction 2 bait 0 mail/h: 18 total 2877017 max/h 8345
	blacklist 0 greylist 0 ratelimit 0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200707/198
X-Sequence-Number: 25882



Arjen van der Meijden wrote:
> Have you also tried the COPY-statement? Afaik select into is similar to 
> what happens in there.

No, because it only works on file to db or vice versa not table to table.

regards

thoams