Database for large scale implementation

[Madhuri]

Hi All - I am designing a system using opentaps/ofbiz for a large scale implementation expecting with an expeced load of 10,000 users. Is anyone aware if such a large scale implementation can be undertaken using postgres?

Thanks Much,
Madhuri

[BJ Freeman]

best answered in the postgresql group.
I think you will find postgresql will coast along as long as you
understand how to use it.

it will also depend on the machine cpu speed and memory.

Madhuri sent the following on 7/24/2008 1:06 AM:
> Hi All - I am designing a system using opentaps/ofbiz for a large scale
> implementation expecting with an expeced load of 10,000 users. Is anyone
> aware if such a large scale implementation can be undertaken using postgres?
>
> Thanks Much,
> Madhuri

[Jacques Le Roux]

I can testify that OFBIz is able to serve at least 25 000 orders a day... Of course, hardware, bandwidth and a good warehousing
organisation are needed..

Jacques

From: "Madhuri" <[hidden email]>

>
> Hi All - I am designing a system using opentaps/ofbiz for a large scale
> implementation expecting with an expeced load of 10,000 users. Is anyone
> aware if such a large scale implementation can be undertaken using postgres?
>
> Thanks Much,
> Madhuri
> --
> View this message in context: http://www.nabble.com/Database-for-large-scale-implementation-tp18627182p18627182.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Ashish Vijaywargiya]

Postgres is the best DB to go on the Production setup.
We are extensively using Postgres for our development as well as for our
client who has bulky data.
Postgres is very fast & very secure.


On Fri, Jul 25, 2008 at 1:41 AM, Jacques Le Roux <
[hidden email]> wrote:

> I can testify that OFBIz is able to serve at least 25 000 orders a day...
> Of course, hardware, bandwidth and a good warehousing organisation are
> needed..
>
> Jacques
>
> From: "Madhuri" <[hidden email]>
>
>
>> Hi All - I am designing a system using opentaps/ofbiz for a large scale
>> implementation expecting with an expeced load of 10,000 users. Is anyone
>> aware if such a large scale implementation can be undertaken using
>> postgres?
>>
>> Thanks Much,
>> Madhuri
>> --
>> View this message in context:
>> http://www.nabble.com/Database-for-large-scale-implementation-tp18627182p18627182.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>
>

--
Ashish Vijaywargiya
Indore (M.P), India
http://en.wikipedia.org/wiki/Indore

[Jacques Le Roux]

Yes, true : Postgres was also used in the project I spoke about below. Postgres is also my preferred DB. Note though that using
version below 8 (7.4 for instance) is not good for OFBiz, 8.0 to 8.3 are doing well so far. I will recommend using the last version
and follow Postgres ML...

Jacques

From: "Ashish Vijaywargiya" <[hidden email]>

> Postgres is the best DB to go on the Production setup.
> We are extensively using Postgres for our development as well as for our
> client who has bulky data.
> Postgres is very fast & very secure.
>
>
> On Fri, Jul 25, 2008 at 1:41 AM, Jacques Le Roux <
> [hidden email]> wrote:
>
>> I can testify that OFBIz is able to serve at least 25 000 orders a day...
>> Of course, hardware, bandwidth and a good warehousing organisation are
>> needed..
>>
>> Jacques
>>
>> From: "Madhuri" <[hidden email]>
>>
>>
>>> Hi All - I am designing a system using opentaps/ofbiz for a large scale
>>> implementation expecting with an expeced load of 10,000 users. Is anyone
>>> aware if such a large scale implementation can be undertaken using
>>> postgres?
>>>
>>> Thanks Much,
>>> Madhuri
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Database-for-large-scale-implementation-tp18627182p18627182.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>>
>>
>
>
> --
> Ashish Vijaywargiya
> Indore (M.P), India
> http://en.wikipedia.org/wiki/Indore
>

[Madhuri]

THank you very much.

Regards,
Madhuri

Ashish Vijaywargiya-4 wrote

Postgres is the best DB to go on the Production setup.
We are extensively using Postgres for our development as well as for our
client who has bulky data.
Postgres is very fast & very secure.


On Fri, Jul 25, 2008 at 1:41 AM, Jacques Le Roux <
[e-mail]> wrote:

> I can testify that OFBIz is able to serve at least 25 000 orders a day...
> Of course, hardware, bandwidth and a good warehousing organisation are
> needed..
>
> Jacques
>
> From: "Madhuri" <[e-mail]>
>
>
>> Hi All - I am designing a system using opentaps/ofbiz for a large scale
>> implementation expecting with an expeced load of 10,000 users. Is anyone
>> aware if such a large scale implementation can be undertaken using
>> postgres?
>>
>> Thanks Much,
>> Madhuri
>> --
>> View this message in context:
>> http://www.nabble.com/Database-for-large-scale-implementation-tp18627182p18627182.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>
>


--
Ashish Vijaywargiya
Indore (M.P), India
http://en.wikipedia.org/wiki/Indore

[Madhuri]

Thanks Much..

Regards,
Madhuri

jacques.le.roux wrote

Yes, true : Postgres was also used in the project I spoke about below. Postgres is also my preferred DB. Note though that using
version below 8 (7.4 for instance) is not good for OFBiz, 8.0 to 8.3 are doing well so far. I will recommend using the last version
and follow Postgres ML...

Jacques

From: "Ashish Vijaywargiya" <[e-mail]>
> Postgres is the best DB to go on the Production setup.
> We are extensively using Postgres for our development as well as for our
> client who has bulky data.
> Postgres is very fast & very secure.
>
>
> On Fri, Jul 25, 2008 at 1:41 AM, Jacques Le Roux <
> [e-mail]> wrote:
>
>> I can testify that OFBIz is able to serve at least 25 000 orders a day...
>> Of course, hardware, bandwidth and a good warehousing organisation are
>> needed..
>>
>> Jacques
>>
>> From: "Madhuri" <[e-mail]>
>>
>>
>>> Hi All - I am designing a system using opentaps/ofbiz for a large scale
>>> implementation expecting with an expeced load of 10,000 users. Is anyone
>>> aware if such a large scale implementation can be undertaken using
>>> postgres?
>>>
>>> Thanks Much,
>>> Madhuri
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Database-for-large-scale-implementation-tp18627182p18627182.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>>
>>
>
>
> --
> Ashish Vijaywargiya
> Indore (M.P), India
> http://en.wikipedia.org/wiki/Indore
>