Postgresql ofbiz building up pool processes

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Postgresql ofbiz building up pool processes

BJ Freeman
started up ofbiz latest sVN with postgresql 7.1.4
I have been monitoring the processes and not that I am increasing the
connections to postgresql but there is not cpu time.

have not looked into the current pooling ofbiz uses.
should not there be a minimum number, and time to return to pool?
about 3 hours ago I had 2 connection now I have 8.
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql ofbiz building up pool processes

Jacques Le Roux
Administrator
I'm not sure what is your concern but  I think there was issues using postgresql before version 8.1. At least I was running my demo
box with postgresql 7.2.? and sometimes I found OFBiz stale. No problems using Derby or PostGresql 8.1 or 8.2

Jacques

De : "BJ Freeman" <[hidden email]>
> started up ofbiz latest sVN with postgresql 7.1.4
> I have been monitoring the processes and not that I am increasing the
> connections to postgresql but there is not cpu time.
>
> have not looked into the current pooling ofbiz uses.
> should not there be a minimum number, and time to return to pool?
> about 3 hours ago I had 2 connection now I have 8.

Reply | Threaded
Open this post in threaded view
|

Re: Postgresql ofbiz building up pool processes

BJ Freeman
my concern is memory usage that eventually these will use up all the
memory in production box.

I am still learning Linux and I am getting a crash course in Distros
that have gotchas.
Currently using Red hat 4ES, as of 3 days ago. I know I can upgrade to
8.2 but have not learn how yet.




Jacques Le Roux sent the following on 8/26/2007 12:06 AM:

> I'm not sure what is your concern but  I think there was issues using postgresql before version 8.1. At least I was running my demo
> box with postgresql 7.2.? and sometimes I found OFBiz stale. No problems using Derby or PostGresql 8.1 or 8.2
>
> Jacques
>
> De : "BJ Freeman" <[hidden email]>
>> started up ofbiz latest sVN with postgresql 7.1.4
>> I have been monitoring the processes and not that I am increasing the
>> connections to postgresql but there is not cpu time.
>>
>> have not looked into the current pooling ofbiz uses.
>> should not there be a minimum number, and time to return to pool?
>> about 3 hours ago I had 2 connection now I have 8.
>
>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql ofbiz building up pool processes

Jacques Le Roux
Administrator
BJ,

You may try Ubuntu 6.02 LTS, works like a charm using Postgres 8.1 or later ... (LTS stands for Long Time Support: 5 years)

Jacques

De : "BJ Freeman" <[hidden email]>

> my concern is memory usage that eventually these will use up all the
> memory in production box.
>
> I am still learning Linux and I am getting a crash course in Distros
> that have gotchas.
> Currently using Red hat 4ES, as of 3 days ago. I know I can upgrade to
> 8.2 but have not learn how yet.
>
>
>
>
> Jacques Le Roux sent the following on 8/26/2007 12:06 AM:
> > I'm not sure what is your concern but  I think there was issues using postgresql before version 8.1. At least I was running my
demo

> > box with postgresql 7.2.? and sometimes I found OFBiz stale. No problems using Derby or PostGresql 8.1 or 8.2
> >
> > Jacques
> >
> > De : "BJ Freeman" <[hidden email]>
> >> started up ofbiz latest sVN with postgresql 7.1.4
> >> I have been monitoring the processes and not that I am increasing the
> >> connections to postgresql but there is not cpu time.
> >>
> >> have not looked into the current pooling ofbiz uses.
> >> should not there be a minimum number, and time to return to pool?
> >> about 3 hours ago I had 2 connection now I have 8.
> >
> >
> >
> >

Reply | Threaded
Open this post in threaded view
|

Re: Postgresql ofbiz building up pool processes

BJ Freeman
thanks for the suggestion, I would but I don't have control of the distros.
took three tries to get something that would run sun Java SDK
:(



Jacques Le Roux sent the following on 8/26/2007 3:50 AM:

> BJ,
>
> You may try Ubuntu 6.02 LTS, works like a charm using Postgres 8.1 or later ... (LTS stands for Long Time Support: 5 years)
>
> Jacques
>
> De : "BJ Freeman" <[hidden email]>
>> my concern is memory usage that eventually these will use up all the
>> memory in production box.
>>
>> I am still learning Linux and I am getting a crash course in Distros
>> that have gotchas.
>> Currently using Red hat 4ES, as of 3 days ago. I know I can upgrade to
>> 8.2 but have not learn how yet.
>>
>>
>>
>>
>> Jacques Le Roux sent the following on 8/26/2007 12:06 AM:
>>> I'm not sure what is your concern but  I think there was issues using postgresql before version 8.1. At least I was running my
> demo
>>> box with postgresql 7.2.? and sometimes I found OFBiz stale. No problems using Derby or PostGresql 8.1 or 8.2
>>>
>>> Jacques
>>>
>>> De : "BJ Freeman" <[hidden email]>
>>>> started up ofbiz latest sVN with postgresql 7.1.4
>>>> I have been monitoring the processes and not that I am increasing the
>>>> connections to postgresql but there is not cpu time.
>>>>
>>>> have not looked into the current pooling ofbiz uses.
>>>> should not there be a minimum number, and time to return to pool?
>>>> about 3 hours ago I had 2 connection now I have 8.
>>>
>>>
>>>
>
>
>
>