From: Thomas Radnetter <tr75@gmx.net>
To: pgsql-performance@postgresql.org
Subject: Performance Problem between Ora 10g and Psql
Date: Wed, 12 Jul 2006 10:33:44 +0200
Message-ID: <20060712083344.4420@gmx.net> (raw)
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" – 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
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-performance@postgresql.org
Cc: tr75@gmx.net
Subject: Re: Performance Problem between Ora 10g and Psql
In-Reply-To: <20060712083344.4420@gmx.net>
* 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