From: Tom Lane <tgl@sss.pgh.pa.us>
To: FERREIRA, William (VALTECH) <william.ferreira@airbus.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: execution plan : Oracle vs PostgreSQL
Date: Wed, 01 Feb 2006 11:04:44 -0500
Message-ID: <901.1138809884@sss.pgh.pa.us> (raw)
In-Reply-To: <414D259CE29DE54DAD534037C83CE4B726961D@FR0-MAILMB20.res.airbus.corp>
References: <414D259CE29DE54DAD534037C83CE4B726961D@FR0-MAILMB20.res.airbus.corp>
"FERREIRA, William (VALTECH)" <william.ferreira@airbus.com> writes:
> My test document has 115000 nodes.
> the export of the document(extracting all informations from database and writing XML file on disk) takes 30s with Oracle and 5mn with Postgresql.
> The Oracle stored procedure is written in pl/sql and the Postgresql stored procedure in pl/perl (using spi_exec).
So the test case involves 115000 executions of the same query via spi_exec?
That means the query will be re-parsed and re-planned 115000 times. If
you want something that's a reasonably fair comparison against Oracle,
try plpgsql which has query plan caching.
regards, tom lane
PS: please do NOT post EXPLAIN VERBOSE output unless someone
specifically asks for it. It clutters the archives and it's usually
useless. EXPLAIN ANALYZE is what we normally want to see for
performance issues.
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: tgl@sss.pgh.pa.us, william.ferreira@airbus.com
Subject: Re: execution plan : Oracle vs PostgreSQL
In-Reply-To: <901.1138809884@sss.pgh.pa.us>
* 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