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 801299FB200 for ; Wed, 12 Jul 2006 06:47:17 -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 97599-08 for ; Wed, 12 Jul 2006 06:47:08 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.180]) by postgresql.org (Postfix) with ESMTP id 471119FB1DC for ; Wed, 12 Jul 2006 06:47:07 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id s49so118136pyc for ; Wed, 12 Jul 2006 02:47:06 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=n+sEIPd6TIiN0Ba+30gC4j6DRJInE30X05pigT3iJR1m3kUK6KqugHGW8fgzC5/V4AYEokUGtt8MvL8cJirNSYKnuEYouCl840GoRCZ3rSIr8omKgrvHEEtfItz8b9Cgx4zxMBn2kGqkW6pLHTlEmkcy6ON6Alqwflc6EJs0L9Y= Received: by 10.35.20.14 with SMTP id x14mr647076pyi; Wed, 12 Jul 2006 02:47:06 -0700 (PDT) Received: by 10.35.53.5 with HTTP; Wed, 12 Jul 2006 02:47:06 -0700 (PDT) Message-ID: <1d4e0c10607120247m4e7e4339p6dd97df9d8c641d7@mail.gmail.com> Date: Wed, 12 Jul 2006 11:47:06 +0200 From: "Guillaume Smet" To: "Thomas Radnetter" Subject: Re: Performance Problem between Ora 10g and Psql Cc: pgsql-performance@postgresql.org In-Reply-To: <20060712083344.4420@gmx.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20060712083344.4420@gmx.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/103 X-Sequence-Number: 19963 Thomas, On 7/12/06, Thomas Radnetter 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