X-Original-To: pgsql-performance-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id A57F59FB1DC
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 12 Jul 2006 05:33:56 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 71578-10 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 12 Jul 2006 05:33:46 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from mail.gmx.net (mail.gmx.net [213.165.64.21])
	by postgresql.org (Postfix) with SMTP id A75849FA634
	for <pgsql-performance@postgresql.org>;
	Wed, 12 Jul 2006 05:33:46 -0300 (ADT)
Received: (qmail 23573 invoked by uid 0); 12 Jul 2006 08:33:44 -0000
Received: from 82.103.0.42 by www032.gmx.net with HTTP;
	Wed, 12 Jul 2006 10:33:44 +0200 (CEST)
Content-Type: multipart/alternative;
	boundary="========GMXBoundary4421152693224656719"
Date: Wed, 12 Jul 2006 10:33:44 +0200
From: "Thomas Radnetter" <tr75@gmx.net>
Message-ID: <20060712083344.4420@gmx.net>
MIME-Version: 1.0
Subject: Performance Problem between Ora 10g and Psql
To: pgsql-performance@postgresql.org
X-Authenticated: #6387982
X-Flags: 0001
X-GMX-UID: mqCBdUZxIyd16iscFWdrU99aa2FkZlWR
X-Mailer: WWW-Mail 6100 (Global Message Exchange)
X-Priority: 3
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200607/102
X-Sequence-Number: 19962

--========GMXBoundary4421152693224656719
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 8bit

Hello!

We're facing a performance problem here in a Oracle 10g -> PostgreSQL 
environment. The Oracle DB accesses the PostgreSQL DB via UnixODBC + 
psqlODBC.

There are some 100 records on the Oracle DB to be updated with data 
obtained from a view of the PostgreSQL DB. The fetched data accumulates to 
a few kB's and the update takes some 5 - 7 hours. During this time the 
PostgreSQL machine is running at approx. 100% CPU usage.
If a select for the same data is issued from the Oracle DB the statement is 
executed in half a second.

Is this the correct place to issue this problem?

How can I trace down the cause for this performance problem?

Thanx in advance!

Regards, 
Thomas Radnetter

p.s. Mr. Ludek Finstrle, can you help again?         

-- 

 "Feel free" &ndash; 10 GB Mailbox, 100 FreeSMS/Monat ...
 Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail     
-- 


"Feel free" – 10 GB Mailbox, 100 FreeSMS/Monat ...
Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail

--========GMXBoundary4421152693224656719
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: 7bit

<html>
    <head>
        <title></title>
        <style media="screen" type="text/css">
body {font-family:verdana, arial, helvetica, sans-serif;font-size:10px;padding:5px;margin:0;background-color:#FFF;}
p, ul, li {margin-top:0;margin-bottom:0;}
blockquote {margin-left:5px;}
div.signature {color:#666;font-size:0.8em;}

body {font-family:verdana, arial, helvetica, sans-serif;font-size:10px;padding:5px;margin:0;background-color:#FFF;}
p, ul, li {margin-top:0;margin-bottom:0;}
blockquote {margin-left:5px;}
div.signature {color:#666;font-size:0.8em;}</style>
    </head>
    <body style="margin: 0pt; padding: 0pt;">
        <font size="3">         Hello!<br /><br />We're facing a performance problem here in a Oracle 10g -&gt; PostgreSQL environment. The Oracle DB accesses the PostgreSQL DB via UnixODBC + psqlODBC.<br /><br />There are some 100 records on the Oracle DB to be updated with data obtained from a view of the PostgreSQL DB. The fetched data accumulates to a few kB's and the update takes some 5 - 7 hours. During this time the PostgreSQL machine is running at approx. 100% CPU usage.<br />If a select for the same data is issued from the Oracle DB the statement is executed in half a second.<br /><br />Is this the correct place to issue this problem?<br /><br />How can I trace down the cause for this performance problem?<br /><br />Thanx in advance!<br /><br /><br />Regards, <br />Thomas Radnetter<br /><br />p.s. Mr. Ludek Finstrle, can you help again?</font>
        <div class="signature"> <br /><br /><br />-- <br /><br /><br /> &quot;Feel free&quot; &ndash; 10 GB Mailbox, 100 FreeSMS/Monat ...<br /> Jetzt GMX TopMail testen: <a href="http://www.gmx.net/de/go/topmail">http://www.gmx.net/de/go/topmail</a> </div>
    <div class="signature"><br /><br /><br />-- <br /><br /><br />
"Feel free" &#x2013; 10 GB Mailbox, 100 FreeSMS/Monat ...<br/>
Jetzt GMX TopMail testen: <a href="http://www.gmx.net/de/go/topmail">http://www.gmx.net/de/go/topmail</a>
</div></body>
</html>

--========GMXBoundary4421152693224656719--