Re: Import Performance

From: "Anthony E (dot) Greene" <agreene(at)pobox(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Import Performance
Date: 2001-02-08 08:03:57
Message-ID: 20010208030357.E4085@cp5340
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 07 Feb 2001 15:09:07 Konstantinos Agouros wrote:
>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?

Yes. Just remember to drop indexes before the import and re-add them
afterward.

Tony
--
Anthony E. Greene <agreene(at)pobox(dot)com> <http://www.pobox.com/~agreene/>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 239D
Chat: AOL/Yahoo: TonyG05 ICQ: 91183266
Linux. The choice of a GNU Generation. <http://www.linux.org/>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Anand Raman 2001-02-08 08:06:21 locks..
Previous Message Lincoln Yeoh 2001-02-08 02:54:56 Re: full text searching