Re: Poor performance in Porting Oracle based application to PostgreSQL

Neil Conway <nconway@klamath.dyndns.org> writes:
> "Roberto Nanamura" <roberto@summa-tech.com> wrote:
>> 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.

> We'll need more information in order to be able to make any meaningful
> comments. Can you post the relevent parts of the schema? How much data
> are you storing, how many updates/inserts are being executed? How large is
> the performance degredation? If relevant, post the query plan for the
> problematic queries (use EXPLAIN).

And there are the usual questions: have you vacuum analyzed?  Have you
done any tuning (installing appropriate indexes, etc)?  Finally, I'd
certainly recommend an update to PG 7.2.1...

            regards, tom lane