| From: | "Thomas Radnetter" <tr75(at)gmx(dot)net> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Performance Problem between Ora 10g and Psql |
| Date: | 2006-07-12 08:33:44 |
| Message-ID: | 20060712083344.4420@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Smet | 2006-07-12 09:47:06 | Re: Performance Problem between Ora 10g and Psql |
| Previous Message | nicky | 2006-07-12 07:38:30 | Out of Memory Problem. |