X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4DFD3D8134 for ; Fri, 23 Sep 2005 06:31:34 -0300 (ADT) 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 11690-02 for ; Fri, 23 Sep 2005 09:31:29 +0000 (GMT) Received: from thor.netera.se (thor.netera.se [85.112.172.11]) by svr1.postgresql.org (Postfix) with ESMTP id 4018ED8CE7 for ; Fri, 23 Sep 2005 06:31:28 -0300 (ADT) Received: from [192.168.2.240] (1-1-1-41a.o.sth.bostream.se [81.26.246.14]) by thor.netera.se (Postfix) with ESMTP id 362EF13AC07A; Fri, 23 Sep 2005 11:31:28 +0200 (CEST) Message-ID: <4333CB6D.1010208@relevanttraffic.se> Date: Fri, 23 Sep 2005 11:31:25 +0200 From: Ulrich Wisser Organization: Relevant Traffic AB User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Joost Kraaijeveld Cc: Pgsql-Performance Subject: Re: How to determine cause of performance problem? References: <1127458167.2475.105.camel@Panoramix> In-Reply-To: <1127458167.2475.105.camel@Panoramix> Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 required=5 tests=[AWL=0.001] X-Spam-Level: X-Archive-Number: 200509/278 X-Sequence-Number: 14586 Hi Joost, why do you convert programmatically? I would do something like create sequence s_objectid; insert into prototype.orders(objectid,ordernumber,orderdate,customernumber) select next_val('s_objectid'),ordernummer, orderdatum, klantnummer from odbc.orders Sounds a lot faster to me. /Ulrich