Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id B60F0632AD8
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun,  6 Jun 2010 19:44:15 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 41064-02
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun,  6 Jun 2010 22:44:07 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from 26.mail-out.ovh.net (26.mail-out.ovh.net [91.121.27.225])
	by mail.postgresql.org (Postfix) with SMTP id 4403C632A8F
	for <pgsql-performance@postgresql.org>;
	Sun,  6 Jun 2010 19:44:08 -0300 (ADT)
Received: (qmail 22744 invoked by uid 503); 6 Jun 2010 22:44:07 -0000
Received: from b7.ovh.net (HELO mail427.ha.ovh.net) (213.186.33.57)
	by 26.mail-out.ovh.net with SMTP; 6 Jun 2010 22:44:07 -0000
Received: from b0.ovh.net (HELO queueout) (213.186.33.50)
	by b0.ovh.net with SMTP; 7 Jun 2010 00:37:25 +0200
Received: from par69-8-88-161-102-87.fbx.proxad.net (HELO apollo13)
	(lists%peufeu.com@88.161.102.87)
	by ns0.ovh.net with SMTP; 7 Jun 2010 00:37:24 +0200
Content-Type: text/plain; charset=utf-8; format=flowed; delsp=yes
To: "Joachim Worringen" <joachim.worringen@iathh.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: performance of temporary vs. regular tables
References: <4BFB837C.6010005@iathh.de>
	<AANLkTik4_exB6U3GlfLMNIgPSk0G3RVQ8fWBTzwekrke@mail.gmail.com>
	<4BFB91A8.20805@iathh.de> <201005251241.59605.andres@anarazel.de>
	<4BFD4643.9010901@iathh.de> <4BFFA32D.8010009@iathh.de>
	<op.vdn3kgtheorkce@immo.peufeu.com> <4C06547E.2010104@iathh.de>
Date: Mon, 07 Jun 2010 00:37:23 +0200
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
From: "Pierre C" <lists@peufeu.com>
Message-ID: <op.vdwg4ly6eorkce@apollo13>
In-Reply-To: <4C06547E.2010104@iathh.de>
User-Agent: Opera Mail/10.10 (Linux)
X-Ovh-Tracer-Id: 2532148890680952554
X-Ovh-Remote: 88.161.102.87 (par69-8-88-161-102-87.fbx.proxad.net)
X-Ovh-Local: 213.186.33.20 (ns0.ovh.net)
X-Spam-Check: DONE|U 0.5/N
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5
	tests=BAYES_40=-0.001
X-Spam-Level: 
X-Archive-Number: 201006/131
X-Sequence-Number: 38987


> Yes, the "other" reason is that I am not issueing a single SQL command,  
> but import data from plain ASCII files through the Pyhton-based  
> framework into the database.
>
> The difference between your measurement and my measurent is the upper  
> potential of improvement for my system (which has, on the other hand,  
> the advantage of being a bit more powerful and flexible than a single  
> SQL statement....;-) )

Ah, in that case ... ;)

You could give pypy a try, sometimes it's a lot slower, sometimes it's a  
lot faster.