Re: performance of temporary vs. regular tables

From: "Pierre C" <lists(at)peufeu(dot)com>
To: "Joachim Worringen" <joachim(dot)worringen(at)iathh(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: performance of temporary vs. regular tables
Date: 2010-06-06 22:37:23
Message-ID: op.vdwg4ly6eorkce@apollo13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Torsten Zühlsdorff 2010-06-07 13:21:13 Re: How to insert a bulk of data with unique-violations very fast
Previous Message Pierre C 2010-06-06 22:35:18 Re: How to insert a bulk of data with unique-violations very fast