Re: JBoss CMP Performance Problems with PostgreSQL 7.2.3

Darryl A. J. Staflund wrote:

>Hi Everyone,
>
>I am developing a JBoss 3.0.x application using PostgreSQL 7.2.3 as a
>back-end database and Solaris 2.8 (SPARC) as my deployment OS. In this
>application, I am using an EJB technology called Container Managed
>Persistence (CMP 2.0) to manage data persistence for me. Instead of
>writing and submitting my own queries to the PostgreSQL database, JBoss is
>doing this for me.
>
>Although this works well for the most part, the insertion of many records
>within the context of a single transaction can take a very long time to
>complete. Inserting 800 records, for instance, can take upward of a
>minute to finish - even though the database is fully indexed and records
>consist of no more than a string field and several foreign key integer
>values.
>
>I think I've tracked the problem down to the way in which PostgreSQL
>manages transactions. Although on the Java side of things I perform all
>my insertions and updates within the context of a single transaction,
>PostgreSQL seems to treat each individual query as a separate transaction
>and this is slowing down performance immensely. Here is a sample of my
>PostgreSQL logging output:
>
>
[...]

I think the problem isn't PostgreSQL. This is the JBoss-CMP. Take a look
on EJB Benchmark from urbancode
(http://www.urbancode.com/projects/ejbbenchmark/default.jsp).

Best Regards,
Rafal

Rafal Kedziorski wrote:

> Darryl A. J. Staflund wrote:
>
> >Hi Everyone,
> >
> >I am developing a JBoss 3.0.x application using PostgreSQL 7.2.3 as a
> >back-end database and Solaris 2.8 (SPARC) as my deployment OS. In this
> >application, I am using an EJB technology called Container Managed
> >Persistence (CMP 2.0) to manage data persistence for me. Instead of
> >writing and submitting my own queries to the PostgreSQL database, JBoss is
> >doing this for me.
> >
> >Although this works well for the most part, the insertion of many records
> >within the context of a single transaction can take a very long time to
> >complete. Inserting 800 records, for instance, can take upward of a
> >minute to finish - even though the database is fully indexed and records
> >consist of no more than a string field and several foreign key integer
> >values.
> >
> >I think I've tracked the problem down to the way in which PostgreSQL
> >manages transactions. Although on the Java side of things I perform all
> >my insertions and updates within the context of a single transaction,
> >PostgreSQL seems to treat each individual query as a separate transaction
> >and this is slowing down performance immensely. Here is a sample of my
> >PostgreSQL logging output:
> >
> >
> [...]
>
> I think the problem isn't PostgreSQL. This is the JBoss-CMP. Take a look
> on EJB Benchmark from urbancode
> (http://www.urbancode.com/projects/ejbbenchmark/default.jsp).
>
> Best Regards,
> Rafal
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

I think the problem is not in the jboss.
I am using pg + jboss from a long time and if you know how to wirk with it the
combination is excelent.
The main problem in this case is CMP and also EntityBeans.
By CMP jboss will try to insert this 800 records separate.
In this case pg will be slow.

I never got good results by using EB and CMP.
If you will to have working produkt use BMP.
regards,
ivan.

You may want to look at this tool as well:

http://hibernate.bluemars.net/1.html

On Thursday 13 February 2003 3:01 am, pginfo wrote:
> Rafal Kedziorski wrote:
> > Darryl A. J. Staflund wrote:
> > >Hi Everyone,
> > >
> > >I am developing a JBoss 3.0.x application using PostgreSQL 7.2.3 as a
> > >back-end database and Solaris 2.8 (SPARC) as my deployment OS. In this
> > >application, I am using an EJB technology called Container Managed
> > >Persistence (CMP 2.0) to manage data persistence for me. Instead of
> > >writing and submitting my own queries to the PostgreSQL database, JBoss
> > > is doing this for me.
> > >
> > >Although this works well for the most part, the insertion of many
> > > records within the context of a single transaction can take a very long
> > > time to complete. Inserting 800 records, for instance, can take upward
> > > of a minute to finish - even though the database is fully indexed and
> > > records consist of no more than a string field and several foreign key
> > > integer values.
> > >
> > >I think I've tracked the problem down to the way in which PostgreSQL
> > >manages transactions. Although on the Java side of things I perform all
> > >my insertions and updates within the context of a single transaction,
> > >PostgreSQL seems to treat each individual query as a separate
> > > transaction and this is slowing down performance immensely. Here is a
> > > sample of my PostgreSQL logging output:
> >
> > [...]
> >
> > I think the problem isn't PostgreSQL. This is the JBoss-CMP. Take a look
> > on EJB Benchmark from urbancode
> > (http://www.urbancode.com/projects/ejbbenchmark/default.jsp).
> >
> > Best Regards,
> > Rafal
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
> I think the problem is not in the jboss.
> I am using pg + jboss from a long time and if you know how to wirk with it
> the combination is excelent.
> The main problem in this case is CMP and also EntityBeans.
> By CMP jboss will try to insert this 800 records separate.
> In this case pg will be slow.
>
> I never got good results by using EB and CMP.
> If you will to have working produkt use BMP.
> regards,
> ivan.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

--
Nick Pavlica
EchoStar Communications
CAS-Engineering
(307)633-5237