Re: Speeds using a transaction vrs not - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Speeds using a transaction vrs not
Date
Msg-id 421DFDAB.5000801@archonet.com
Whole thread Raw
In response to Re: Speeds using a transaction vrs not  ("Joel Fradkin" <jfradkin@wazagua.com>)
List pgsql-sql
Joel Fradkin wrote:
> Thanks.
> 
> I guess I could add that logic, but this is a one time process going to run
> the night we go live on postgres.
> With .net it took like 2 hours to do the whole shebang, so I am happy.

Fair enough. I tend to produce a text-file and use COPY for bulk 
transfers, but that's just me.

> I did convert a fairly large app and it seemed to run faster on the postgres
> box then the MSSQL box, so my first project after actually getting the data
> and views has gone very smooth.

Don't forget to set aside some time for tweaking configuration settings 
so you can tune the system.

--  Richard Huxton  Archonet Ltd


pgsql-sql by date:

Previous
From: "Joel Fradkin"
Date:
Subject: Re: Postgres 8 - Database access, new install.
Next
From: Alexis Vasquez
Date:
Subject: Unsuscribe