Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Performance Problem between Ora 10g and Psql
- From: "Thomas Radnetter" <tr75(at)gmx(dot)net>
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Performance Problem between Ora 10g and Psql
- Date: Wed, 12 Jul 2006 10:33:44 +0200
- Message-id: <20060712083344.4420@gmx.net> <text/plain>
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
- Follow-Ups:
- Re: Performance Problem between Ora 10g and Psql
- From: Joshua D. Drake
- Re: Performance Problem between Ora 10g and Psql
- From: Guillaume Smet
- Re: Performance Problem between Ora 10g and Psql
- Prev by Date: Out of Memory Problem.
- Next by Date: Re: Performance Problem between Ora 10g and Psql
- Previous by thread: Out of Memory Problem.
- Next by thread: Re: Performance Problem between Ora 10g and Psql
- Indexes: