Re: How to determine cause of performance problem? - Mailing list pgsql-performance

From Ulrich Wisser
Subject Re: How to determine cause of performance problem?
Date
Msg-id 4333CB6D.1010208@relevanttraffic.se
Whole thread Raw
In response to How to determine cause of performance problem?  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: K C Lau
Date:
Subject: Re: SELECT LIMIT 1 VIEW Performance Issue
Next
From: Simon Riggs
Date:
Subject: Releasing memory during External sorting?