From: Guillaume Smet <guillaume.smet@gmail.com>
To: Thomas Radnetter <tr75@gmx.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance Problem between Ora 10g and Psql
Date: Wed, 12 Jul 2006 11:47:06 +0200
Message-ID: <1d4e0c10607120247m4e7e4339p6dd97df9d8c641d7@mail.gmail.com> (raw)
In-Reply-To: <20060712083344.4420@gmx.net>
References: <20060712083344.4420@gmx.net>
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
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: guillaume.smet@gmail.com, tr75@gmx.net
Subject: Re: Performance Problem between Ora 10g and Psql
In-Reply-To: <1d4e0c10607120247m4e7e4339p6dd97df9d8c641d7@mail.gmail.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