Posted by
David E. Jones on
Dec 31, 2005; 12:08am
URL: http://ofbiz.116.s1.nabble.com/Users-Anyone-using-postgres-8-with-ofbiz-tp136826p136827.html
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