From: Joshua D. Drake <jd@commandprompt.com>
To: pgsql-performance@postgresql.org
Cc: Thomas Radnetter <tr75@gmx.net>
Subject: Re: Performance Problem between Ora 10g and Psql
Date: Wed, 12 Jul 2006 07:33:52 -0700
Message-ID: <200607120733.52847.jd@commandprompt.com> (raw)
In-Reply-To: <20060712083344.4420@gmx.net>
References: <20060712083344.4420@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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jd@commandprompt.com, tr75@gmx.net
Subject: Re: Performance Problem between Ora 10g and Psql
In-Reply-To: <200607120733.52847.jd@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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