Re: Speeds using a transaction vrs not

From: Richard Huxton <dev(at)archonet(dot)com>
To: Joel Fradkin <jfradkin(at)wazagua(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Speeds using a transaction vrs not
Date: 2005-02-23 08:02:48
Message-ID: 421C38A8.5010809@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Joel Fradkin wrote:
> I wrote a .net program to move my data to postgres (works great on
> SQ_ASCII).
>
> In fiddling around I tried it using the odbc driver and a transaction
> originally, but converted it to using the .net connectivity but no
> transaction.
>
> What I found was it moved my database (4 gig in MSSQL) in 2 hours using the
> .net, but 12 hours with the odbc and transaction.

You *are* using transactions, you don't have a choice. Did you do the
transfer of all 4GB in ONE transaction with the ODBC? Please describe
the process in more detail.

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Oliver Brück 2005-02-23 08:05:39 Re: No triggers visible for different user in information_schema.triggers
Previous Message Michael Fuhr 2005-02-23 00:26:57 Re: Pagination with Output Variables?