| From: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
|---|---|
| To: | "Roberto Nanamura" <roberto(at)summa-tech(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Poor performance in Porting Oracle based application to PostgreSQL |
| Date: | 2002-06-11 17:27:09 |
| Message-ID: | 20020611132709.0aa833db.nconway@klamath.dyndns.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 10 Jun 2002 12:05:26 -0700
"Roberto Nanamura" <roberto(at)summa-tech(dot)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.
> One of most insert/update intensive tasks is taking double the time it took in
> Oracle.
"It goes slow, what's wrong?"
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).
Cheers,
Neil
--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2002-06-11 17:54:12 | Would a PostgreSQL only hosting environment be of interest? |
| Previous Message | Jan Wieck | 2002-06-11 16:56:09 | Re: View String or Representation |