Performance Problem between Ora 10g and Psql - Mailing list pgsql-performance

From Thomas Radnetter
Subject Performance Problem between Ora 10g and Psql
Date
Msg-id 20060712083344.4420@gmx.net
Whole thread Raw
Responses Re: Performance Problem between Ora 10g and Psql  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Re: Performance Problem between Ora 10g and Psql  ("Joshua D. Drake" <jd@commandprompt.com>)
List 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

pgsql-performance by date:

Previous
From: nicky
Date:
Subject: Out of Memory Problem.
Next
From: "Guillaume Smet"
Date:
Subject: Re: Performance Problem between Ora 10g and Psql