pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Richard Huxton <dev@archonet.com>
To: Joel Fradkin <jfradkin@wazagua.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Speeds using a transaction vrs not
Date: Thu, 24 Feb 2005 16:15:39 +0000
Message-ID: <421DFDAB.5000801@archonet.com> (raw)
In-Reply-To: <002f01c51a88$32fb1f80$797ba8c0@jfradkin>
References: <002f01c51a88$32fb1f80$797ba8c0@jfradkin>

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



view thread (6+ messages)

Message-ID: <421DFDAB.5000801@archonet.com>
Permalink:  ../421DFDAB.5000801@archonet.com/
Also on:    postgresql.org/message-id/421DFDAB.5000801@archonet.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: dev@archonet.com, jfradkin@wazagua.com
  Subject: Re: Speeds using a transaction vrs not
  In-Reply-To: <421DFDAB.5000801@archonet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox