Performance Problem between Ora 10g and Psql
| От | Thomas Radnetter |
|---|---|
| Тема | Performance Problem between Ora 10g and Psql |
| Дата | |
| Msg-id | 20060712083344.4420@gmx.net обсуждение исходный текст |
| Ответы |
Re: Performance Problem between Ora 10g and Psql
Re: Performance Problem between Ora 10g and Psql |
| Список | 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
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
В списке pgsql-performance по дате отправления: