Re: Poor performance in Porting Oracle based application to

Sorry, for not posting the schema. I have asked my manager about that and I am
waiting for the response.

I have just joined the project. I ran a vacuum verbose analyze. See the results
attached.

Ron Snyder wrote:
>
> 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
> >