From: | "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, pgsql-performancel(at)postgresql(dot)org |
Subject: | Re: MS-server <-> Ppostgresql |
Date: | 2002-11-21 12:46:53 |
Message-ID: | 3DDD2315.28806.4AF64EC@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 21 Nov 2002 at 13:35, Francois Sauterey wrote:
> I plan to extract/copy about 120.000 lines from a MS SQL 7 server database
> (on a NT machione) to a postresql database on a Linux machine (debian/woody).
> But what a pity : I obtain (after so many tests, so many compilation with
> so many different options) a copy of about 1200 lines/minute ;~{
> And horror, I plan to make the same thing whith a 3.000.000 lines database.
> Any idea ?
Yes.. Copy inside a transaction. Put something like 10000 lines in a
transaction and then commit. See what speed difference that would make.
If possible use copy. That's fastest. It would insert all of them in one
transaction..
HTH
Bye
Shridhar
--
Battle, n.: A method of untying with the teeth a political knot that will not
yield to the tongue. -- Ambrose Bierce
From | Date | Subject | |
---|---|---|---|
Next Message | Felipe Schnack | 2002-11-21 12:49:37 | Re: MS-server <-> Ppostgresql |
Previous Message | Francois Sauterey | 2002-11-21 12:35:37 | MS-server <-> Ppostgresql |