Re: Users - Anyone using postgres 8 with ofbiz?

Posted by Brett on Dec 31, 2005; 2:04pm
URL: http://ofbiz.116.s1.nabble.com/Users-Anyone-using-postgres-8-with-ofbiz-tp136826p136828.html

Si and David,

Thanks for the information.  We are a few months behind on the ofbiz
source code which is why we don't have the postgres 8 driver from svn.
 I downloaded the postgres 8 driver (postgres1-8.1-404.jdbc3.jar) from
postgres.org and this fixed our performance issues.

I'll also try the driver in the ofbiz repository.

Thanks for the information.


Brett



On 12/30/05, David E. Jones <[hidden email]> wrote:

>
> Brett,
>
> The improvements done to the Postgres 7 driver were to support the
> use of cursors in the database so that large result sets were not
> pulled into memory on the app server. Without this there are
> performance problems, and for larger data sets out of memory errors.
>
> The PG8 driver does include support for cursors, so it should do
> fine. I believe this newer one is the one in SVN right now, though if
> you have an older revision then you may have the modified 7 series
> driver.
>
> -David
>
>
> On Dec 30, 2005, at 4:49 PM, Brett Palmer wrote:
>
> > We have been running ofbiz with postgres 7 on Linux for a couple
> > years.  We are trying to migrate to postgres 8.  We are seeing
> > significant performance degradation when running ofbiz with postgres 8
> > particularly when using large amounts of data.
> >
> > I know there where some performance improvements for the jdbc driver
> > done earlier by Andy.  Does anyone know if there is an updated jdbc
> > driver for postgres 8?
> >
> > I'm going to try the postgres 8 jdbc driver from postgres now.  I'll
> > let you know how it goes.
> >
> >
> > Brett
> >
> > _______________________________________________
> > Users mailing list
> > [hidden email]
> > http://lists.ofbiz.org/mailman/listinfo/users
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users