Poor performance in Porting Oracle based application to PostgreSQL

From: Roberto Nanamura <roberto(at)summa-tech(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Poor performance in Porting Oracle based application to PostgreSQL
Date: 2002-06-10 19:05:26
Message-ID: 3D04F876.FBCF245A@summa-tech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi all,

We are facing a performance degradation when we ported a Weblogic 6.0 sp2 (using
BMP entity EJBs) from Oracle 8.1.7 to PostgreSQL 7.1.3 both using Linux RedHat.
One of most insert/update intensive tasks is taking double the time it took in
Oracle.

Did anyone have this problem before? What are your experiences in porting an BMP
EJB based application from Oracle to PostgreSQL? Is this just a problem of
tuning or it is inherent to PostgreSQL? Can a well-tuned PostgreSQL be that
slower than Oracle?

Thanks for your attention,

Roberto

Attachment Content-Type Size
roberto.vcf text/x-vcard 380 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Snyder 2002-06-10 19:18:30 Re: Checking that Pg is running from a shell script
Previous Message terry 2002-06-10 18:49:33 Re: [SQL] VIEWs and FOREIGN keys