Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id B8FA39FBE92
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 18 Jul 2007 16:13:59 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 55225-06 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 18 Jul 2007 16:13:56 -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 C70809FB5DD
	for <pgsql-performance@postgresql.org>;
	Wed, 18 Jul 2007 16:13:56 -0300 (ADT)
Received: from mail-mx9.uio.no ([129.240.10.39])
	by pat.uio.no with esmtp (Exim 4.67)
	(envelope-from <tfinneid@ifi.uio.no>) id 1IBEyB-0000uW-SF
	for pgsql-performance@postgresql.org; Wed, 18 Jul 2007 21:13:55 +0200
Received: from smtp.uio.no ([129.240.10.9] helo=mail-mx9.uio.no)
	by mail-mx9.uio.no with esmtp (Exim 4.67)
	(envelope-from <tfinneid@ifi.uio.no>) id 1IBEyB-0003oa-CK
	for pgsql-performance@postgresql.org; Wed, 18 Jul 2007 21:13:55 +0200
Received: from 113.80-203-240.nextgentel.com ([80.203.240.113]
	helo=[10.0.0.128])
	by mail-mx9.uio.no with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.67)
	(envelope-from <tfinneid@ifi.uio.no>) id 1IBEyB-0003oM-6U
	for pgsql-performance@postgresql.org; Wed, 18 Jul 2007 21:13:55 +0200
Message-ID: <469E664A.2010205@ifi.uio.no>
Date: Wed, 18 Jul 2007 21:13:14 +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>
	<469D2E1B.1090100@ifi.uio.no> <20070718113249.GI12481@mathom.us>
In-Reply-To: <20070718113249.GI12481@mathom.us>
Content-Type: text/plain; charset=us-ascii; 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, AWL=0.030)
X-UiO-Scanned: 780C9399A96F126EBA997F28EDD1AA4AD0EC767E
X-UiO-SPAM-Test: remote_host: 129.240.10.9 spam_score: 0 maxlevel 200
	minaction 2 bait 0 mail/h: 107 total 2889840 max/h 8345
	blacklist 0 greylist 0 ratelimit 0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200707/228
X-Sequence-Number: 25912



Michael Stone wrote:
> On Tue, Jul 17, 2007 at 11:01:15PM +0200, Thomas Finneid wrote:
>> 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.
> 
> I don't understand how the insert you described is table to table?

SELECT INTO is table to table, so is INSERT INTO SELECT FROM.

regards

thomas