X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 85580550E7 for ; Thu, 24 Feb 2005 16:15:45 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 80321-01 for ; Thu, 24 Feb 2005 16:15:42 +0000 (GMT) Received: from anchor-post-31.mail.demon.net (anchor-post-31.mail.demon.net [194.217.242.89]) by svr1.postgresql.org (Postfix) with ESMTP id 3A4A753C92 for ; Thu, 24 Feb 2005 16:15:41 +0000 (GMT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-31.mail.demon.net with esmtp (Exim 4.42) id 1D4Lcj-0006Rq-3V; Thu, 24 Feb 2005 16:14:06 +0000 Received: from [192.168.1.17] (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 51227180BD; Thu, 24 Feb 2005 16:15:39 +0000 (GMT) Message-ID: <421DFDAB.5000801@archonet.com> Date: Thu, 24 Feb 2005 16:15:39 +0000 From: Richard Huxton User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Joel Fradkin Cc: pgsql-sql@postgresql.org Subject: Re: Speeds using a transaction vrs not References: <002f01c51a88$32fb1f80$797ba8c0@jfradkin> In-Reply-To: <002f01c51a88$32fb1f80$797ba8c0@jfradkin> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.063 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/309 X-Sequence-Number: 20419 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