X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 933389FB377 for ; Wed, 12 Jul 2006 11:34:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 41936-01 for ; Wed, 12 Jul 2006 11:34:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from projects.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id 503F69FB372 for ; Wed, 12 Jul 2006 11:34:01 -0300 (ADT) Received: from [192.168.1.50] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by projects.commandprompt.com (8.13.6/8.13.6) with ESMTP id k6CEXqoq015859; Wed, 12 Jul 2006 07:33:54 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. To: pgsql-performance@postgresql.org Subject: Re: Performance Problem between Ora 10g and Psql Date: Wed, 12 Jul 2006 07:33:52 -0700 User-Agent: KMail/1.9.1 Cc: "Thomas Radnetter" References: <20060712083344.4420@gmx.net> In-Reply-To: <20060712083344.4420@gmx.net> XIDTRACK: jd@commandprompt.com MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200607120733.52847.jd@commandprompt.com> X-Virus-Scanned: ClamAV version 0.88.2, clamav-milter version 0.88.2 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (projects.commandprompt.com [192.168.2.159]); Wed, 12 Jul 2006 07:33:54 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/104 X-Sequence-Number: 19964 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/