Import Performance

From: elwood(at)agouros(dot)de (Konstantinos Agouros)
To: pgsql-general(at)postgresql(dot)org
Subject: Import Performance
Date: 2001-02-07 20:09:07
Message-ID: elwood.981576464@news.agouros.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

after waiting for imports using perl dbi/prepared-statement/inserts I came
across the idea to first create a ;-separated file and then use the copy-
command. Should this be faster after all?

Konstantin
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood(at)agouros(dot)de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not sustain the forming of the cosmos." B'Elana Torres

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Sawtell 2001-02-07 22:00:42 Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference?
Previous Message Albert REINER 2001-02-07 19:57:07 Re: Re: SQL Join - MySQL/PostgreSQL difference?