Re: Poor performance in Porting Oracle based applicatio

I don't have any experience with taking weblogic from oracle to postgres,
but you might try posting some more details regarding the insert/update that
you are doing.

I'd also recommend (since you're just at the beginning of your project?)
that you switch to postgres 7.2.1 instead of using 7.1.3. This will allow
you to run vacuums without locking the table.

Have you run a vacuum analyze, as well?

-ron

> -----Original Message-----
> From: Roberto Nanamura [mailto:roberto(at)summa-tech(dot)com]
> Sent: Monday, June 10, 2002 12:05 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Poor performance in Porting Oracle based
> application to PostgreSQL
>
>
>
> 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
>