pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Performance Problem between Ora 10g and Psql 3+ messages / 3 participants [nested] [flat]
* Performance Problem between Ora 10g and Psql @ 2006-07-12 08:33 Thomas Radnetter <tr75@gmx.net> 2006-07-12 09:47 ` Re: Performance Problem between Ora 10g and Psql Guillaume Smet <guillaume.smet@gmail.com> 2006-07-12 14:33 ` Re: Performance Problem between Ora 10g and Psql Joshua D. Drake <jd@commandprompt.com> 0 siblings, 2 replies; 3+ messages in thread From: Thomas Radnetter @ 2006-07-12 08:33 UTC (permalink / raw) To: 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Performance Problem between Ora 10g and Psql 2006-07-12 08:33 Performance Problem between Ora 10g and Psql Thomas Radnetter <tr75@gmx.net> @ 2006-07-12 09:47 ` Guillaume Smet <guillaume.smet@gmail.com> 1 sibling, 0 replies; 3+ messages in thread From: Guillaume Smet @ 2006-07-12 09:47 UTC (permalink / raw) To: Thomas Radnetter <tr75@gmx.net>; +Cc: pgsql-performance Thomas, On 7/12/06, Thomas Radnetter <tr75@gmx.net> wrote: > Is this the correct place to issue this problem? It is if your issue is due to a PostgreSQL performance problem. > How can I trace down the cause for this performance problem? The first thing to do is to determine if it is a problem due to the Oracle -> ODBC -> PostgreSQL thing or if it is a problem with the query. My advice is to set log_min_duration_statement to 0 in your postgresql.conf (and set the logger so that you can see the log output somewhere). Then you'll see if your query is slow. If your query is slow, post the output of an explain analyze on the list with all the relevant information (structure of the concerned tables, indexes, size...). If not, it's probably more an ODBC problem. Regards, -- Guillaume Smet Open Wide ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Performance Problem between Ora 10g and Psql 2006-07-12 08:33 Performance Problem between Ora 10g and Psql Thomas Radnetter <tr75@gmx.net> @ 2006-07-12 14:33 ` Joshua D. Drake <jd@commandprompt.com> 1 sibling, 0 replies; 3+ messages in thread From: Joshua D. Drake @ 2006-07-12 14:33 UTC (permalink / raw) To: pgsql-performance; +Cc: Thomas Radnetter <tr75@gmx.net> On Wednesday 12 July 2006 01:33, Thomas Radnetter wrote: > 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? Sure but you haven't provided a TON of information that would be needed to help? If you execute the same query that is being executed via ODBC, via psql is the performance problem still there? If so, you probably have a postgresql issue, otherwise look at Oracle or ODBC. If it is a PostgreSQL issue: Do you have indexes applied? What is the explain plan? When was the last time you analyzed? What about vacuum? etc. etc. Sincerely, Joshua D. Drake > > 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 -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-07-12 14:33 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2006-07-12 08:33 Performance Problem between Ora 10g and Psql Thomas Radnetter <tr75@gmx.net> 2006-07-12 09:47 ` Guillaume Smet <guillaume.smet@gmail.com> 2006-07-12 14:33 ` Joshua D. Drake <jd@commandprompt.com>
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